Search my blog
-
-
Recent Posts
- Reading list for the week – 24/10/11
- Reading list for the week – 17/10/11
- Reading list for the week – 10/10/11
- Reading list for the week – 03/10/11
- Reading list for the week – 26/09/11
- MSP Error: 29528 The setup has encountered an unexpected error while Setting reporting service exclusion path
- Reading list for the week – 19/09/11
Page Views
208,411-
Popular Posts
- How the Cannot generate SSPI context error was fixed
- Find the SQL Server Instance name using Task Manager
- Server is in script upgrade mode. Only administrator can connect at this time
- Script to check database user permissions
- Cannot create an instance of OLE DB provider ‘OraOLEDB.Oracle’ for linked server
Archives
Tags
backup configure data corruption data file hardware hotfix index internals locks maintenance plan performance PradeepAdiga restore RLFTW scripts security services setup sql 2000 sql 2005 sql 2008 sql 2012 sql agent ssis system databases tips and tricks tools Top Posts trace transaction log troubleshoot windows
Tag Archives: performance
Find the SQL Server Instance name using Task Manager
Yesterday one of the servers which hosts 5 instances of SQL Server 2005, the CPU constantly hitting 100% utilization. The Application team using the database on one of the 5 instances started complaining of poor performance. The DBA connected to … Continue reading
Posted in Performance, SQLServerPedia Syndication, Troubleshoot
Tagged performance, services, tips and tricks, tools, windows
8 Comments
sp_sqlagent_get_perf_counters consuming more CPU
While troubleshooting High CPU conditions on a SQL Server instance, many of us would have stumbled upon a session which was executing sp_sqlagent_get_perf_counters stored procedure. As the stored procedure name suggests this is executed approximately every 20 seconds to get … Continue reading
Posted in Configure, SQLServerPedia Syndication
Tagged internals, performance, troubleshoot
Leave a comment
RSS
Email
Twitter
Ovi App
LinkedIn
FourSquare