Welcome to MSDN Blogs Sign in | Join | Help

June 2009 - Posts

Troubleshooting SQL Server deadlocks and performance when running SharePoint

I’ve worked on a lot of cases this year involving SharePoint. Here are some example problems I encountered recently. If you want to read the background or the formal advice first, here are some good starting links Planning and Monitoring SQL Server Storage

Download location for SQLDIAG Perfstats DMV scripts

I refer to this many times in my other posts, so here’s a direct link to the download location of the perfstats scripts for SQLDIAG which you can use yourself. I use this everyday, you should too! http://blogs.msdn.com/psssql/archive/2007/02/21/sql-server-2005-performance-statistics-script.asp
Posted by grahamk | 1 Comments
Filed under: ,

SQL Server 2005 Error: 701, Severity: 17, State: 193

Here’s another interesting example which we worked recently in the Stockholm office, which relates also back to one of my previous entries. We had a customer whose error log was filled with a variety of critical errors such as these: Error: 701, Severity:
Posted by grahamk | 1 Comments
 
Page view tracker