Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » performance   (RSS)
Monday, June 15, 2009 10:01 AM

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
Posted by grahamk | 0 Comments
Monday, March 30, 2009 5:32 PM

Unable to use forced parameterization when deploying plan guides in SQL Server 2005

I was working a case last week where I wanted to instate some fairly simple plan guides for a query that had picked a bad plan on a particular deployment of an application. I was thinking it was going to be an easy process. The query in question executed
Posted by grahamk | 1 Comments
Filed under: , ,
Wednesday, February 11, 2009 7:43 PM

Compilation Bottlenecks – Error: 8628, Severity: 17, State: 0. – Part 2

[follow up to RESOURCE_SEMAPHORE_QUERY_COMPILE diagnosis] Last week I wrote about the initial diagnosis of this problem, and now here's the follow up. So if you remember we had a DBCC MEMORYSTATUS and a load of other PSSDIAG data collected and we knew
Posted by grahamk | 1 Comments
Tuesday, February 03, 2009 3:33 PM

SQL Server Compilation Bottlenecks – Error: 8628, Severity: 17, State: 0. – Part 1

[alternative title: Memory Troubleshooting using DBCC MEMORYSTATUS] The following samples are taken from a live problem I was working on for most of last week. The steps might well help you resolve an occurrence of the above error, but the methodology
Posted by grahamk | 2 Comments
Monday, February 02, 2009 4:48 PM

Which sessionid has the most locks in a SQL Server instance

Quick post today. Was playing around with something on Friday night, thinking how to answer this question quickly whilst looking a live performance problem. I have a huge selection of ready to go DMV based queries, aimed at targetting all types of performance
Posted by grahamk | 2 Comments
Filed under: , , ,
Tuesday, December 16, 2008 12:47 PM

Changes to management of 'TokenAndPermUserStore' in SQL 2005 SP3

SQL Server 2005 service pack 3 released today and you can download it from here: http://www.microsoft.com/downloads/details.aspx?FamilyID=ae7387c3-348c-4faa-8ae5-949fdfbe59c4&displaylang=en One of the most interesting and useful bits which I am interested
Posted by grahamk | 0 Comments
Thursday, November 13, 2008 4:54 PM

Interesting things to watch out for when using the autoclose database option

Here's something which I've been looking at this week, surrounding the autoclose database option. When you restore any database to a SQL Server 2005 SP2 or later instance, you'll more than likely get errors of this nature written to the log. 2008-11-12
Posted by grahamk | 2 Comments
Monday, June 30, 2008 5:03 PM

SQL Server Performance Assessment – What are my top 20 expensive batches

Previously here , I discussed the nature of collecting data when you are experiencing a SQL Server performance problem. A performance problem sometimes intimidates people as they are not sure where to start. This post details one of my preferred ways
Posted by grahamk | 1 Comments
Attachment(s): top20batches.sql
Friday, May 16, 2008 4:03 PM

Slow recovery times and slow performance due to large numbers of Virtual Log Files

In my previous post about database mirroring configuration problems caused by large numbers of virtual log files, I mentioned that such a scenario can have other unwanted side effects, with or without database mirroring being enabled. Here’s an example
Posted by grahamk | 1 Comments
Monday, April 14, 2008 8:38 PM

Performance Problems in SQL Server - What data should I collect?

If you ever talk to me or any of my colleagues in the SQL Server PSS support team, and you have a suspected SQL Server performance problem, you’ll undoubtedly be asked to run the PSSDIAG tool which usually collects the data that we need. This tool
Posted by grahamk | 5 Comments
Monday, April 14, 2008 5:10 PM

Somewhere to start

Following my guest posts with Tess, here and here , I thought it would be interesting to expand some of the topics further, so here we are. First off I'll start with a revision of the "what data to collect" post, with a couple of small additions.
Posted by grahamk | 0 Comments
 
Page view tracker