Monthly Archives: February 2012

SQL Server Monitoring Pt. 2 – Run a SQL Profiler trace during high usage hours

As my research continues I should point out that these tools are pretty sharp. SQL Profiler while not the sharpest ax in the tool box, it’s still a very powerful tool. There are numerous traces you can run to iron out the most simple problems. There are some … Continue reading

Posted in Uncategorized | 1 Comment

SQL Server Monitoring

It was only in due time “Erik please find a third party tool that can monitor our database for performance issues and blocking.” The time is now. So in my option I have about three options. Create a custom script to monitor for blocking … Continue reading

Posted in Uncategorized | Leave a comment