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.