Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » SQL Server   (RSS)

SQL Server High CPU caused by trace filter

Consider the scenario where you take several memory dumps from SQL Server because you are getting very high CPU without apparent reason. After looking at this memory dumps you notice that almost every thread has a call stack similar to the one below then
Posted by Cuko | 0 Comments
Filed under: ,

Troubleshooting blocking issues in SQL Server 2000 and 2005

Most of my work is supporting and troubleshooting production environments and very often developers I work with say “We are having some performance issues in our website and we believe the bottleneck is in SQL Server. We have collected some profilers
Posted by Cuko | 2 Comments
 
Page view tracker