May 8, 2008 at 8:53 am
Hello everybody,
I need to know if there is any good(excellent) tool so that i can check performance, create reports, do optimizations in my SQL Server Instances.
I've installed a new cluster that at the beginning he performance was fantastic. Now 3 months after i've done that migration my cluster is completely down :crazy:
The cluster is formed by two quad core machines with 16GB of RAM and i cant explain to my client what is happening on the cluster.
When i activate my performance monitor ,what options should i check to get this information?
How can i get this precious info without getting the server down.
Thanks and regards
JMSM 😉
May 8, 2008 at 9:06 am
you should have a baseline to know if performance is down:
http://www.sqlservercentral.com/articles/Administering/performancemonitoringbasiccounters/1348/
http://www.sql-server-performance.com/articles/per/hardware_tuning_performance_p1.aspx
May 9, 2008 at 8:51 am
Thanks a lot
Regards.
JMSM 😉
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply