up vote 0 down vote favorite
share [g+] share [fb]

We have an SQL server 2005 on Windows Server 2008. SQL server performance is not consistent through out the day. For example, a procedure that takes less than 5 seconds usually, takes around 30 to 45 seconds sometimes. In a few cases, this procedures has taken even 180 seconds. When we did a little bit of troubleshooting, we felt, though not sure, that the was hardly any load on the server.

So to understand what is/are causing the server become slow, we thought of monitoring disk space, memory, cup load etc for 24/7. We found powershell scripts at this link and used them. But they are not polished and do not seem work well. Any ideas, pointers to help us monitor this server for its heath is appreciated.

link|improve this question
feedback

3 Answers

up vote 2 down vote accepted

We have used Paessler PRTG for this and it is easy to install and configure using WMI and SNMP (Among other things) The free version will give 10 sensor and a simple update will get you 20 sensors and there is a free trial of the full product. Supports e-mail alerts if certain conditions defined by you are met. Helped us identify issues quickly. PRTG

link|improve this answer
1  
I installed this application and configured it with 8 sensors. It is working quite well. Thanks for pointing me in the right direction. – mohang Jun 17 '11 at 7:07
feedback
up vote 1 down vote

If you do not like PerfMon, there is also XPerf for the "hardcore" among us. I am still trying to get through the documentation . . . eventually.

link|improve this answer
Though this seems promising, the download page talked about a few issues with the download of SDK. So I did not do this as it is a production level server. – mohang Jun 17 '11 at 7:08
feedback
up vote 0 down vote

The standard Windows performance monitor application is capable of monitoring servers through the network.

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.