Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » Performance   (RSS)
Wednesday, October 01, 2008 5:06 PM

Windows Scalable Networking Pack – Possible Performance and Concurrency Impacts to SQL Server Workloads

The Scalable Networking Pack aka. SNP (TCP Chimney, RSS and NetDMA) is enabled by default if you apply Windows Server 2003 Sp2.  This is an operating system feature that provides capability to offload TCP/IP packet processing from the processor to
Posted by psssql | 3 Comments
Filed under:
Wednesday, August 27, 2008 10:18 PM

Using Locking Like Synchronization Object

This post is more of a T-SQL trick and NOT a recommendation practice, but since I addressed this in a recent customer case I thought I would share it. Problem:   Application needs to lock a row for the duration of the transaction and ensure no data
Posted by psssql | 2 Comments
Filed under: ,
Tuesday, July 08, 2008 2:24 PM

SQL Server I/O Bottleneck, I don't have one, YES YOU DO!

The mistake I see people make is when looking at the SQL Server PAGE I/O waits and stalled I/O warnings is when comparing it to the Avg. Disk Seconds/Transfer.    Everyone seems to forget that average means average and they look at the
Posted by psssql | 1 Comments
Tuesday, June 17, 2008 5:50 PM

Helpful Hint: Making Review of a Query Plan Easier

I think we all have looked at the output of statistics profile and wished the Estimated Rows and Estimated Executions columns were placed beside the Rows and Executes columns.  Well, they can be. In grid mode you simply drag the columns beside each
Posted by psssql | 1 Comments
Filed under:
Monday, June 16, 2008 5:20 AM

Query Performance issues associated with a large sized security cache

In the past couple of months, SQL Server support team has come across some customers running into performance issues attributed to TokenAndPermUserStore in SQL Server 2005. This blog post attempts to compile all the information we have so far regarding
Posted by psssql | 3 Comments
Monday, April 21, 2008 3:12 PM

How It Works: What is a Sleeping / Awaiting Command Session

This issue is as old as SQL Server.  In fact, it goes back to Sybase days but continues to fool and puzzle administrators. A session with that status of sleeping / awaiting command is simply a client connection with no active query to the SQL Server.
Posted by psssql | 1 Comments
Friday, March 28, 2008 7:03 PM

How It Works: SQL Server 2005 DBCC Shrink* May Take Longer Than SQL Server 2000

SQL Server 2005 adds additional shrink logic to compress TEXT/IMAGE data, referred to as LOBs.     The dbcc shrink* code uses the same underlying methods that ALTER INDEX .... WITH (LOB_COMPACTION ON) uses to compact the LOB space
Posted by psssql | 2 Comments
Monday, March 03, 2008 3:41 PM

SQL Server Working Set Trim Problems? - Consider...

Microsoft support continues to receive a steady flow of cases indicating poor, SQL Server performance symptoms.   When the issue is narrowed down we are finding that the working set of SQL Server and many of the processes on the computer have
Posted by psssql | 2 Comments
Filed under: , ,
Thursday, February 14, 2008 9:35 PM

How It Works: Linked Servers and Collation Compatibility

Customer Question:   "Why I am getting different results when is change collation compatibility from true to false?" This actually turned out to be an interesting issue because no error was raised but the results are different. The query
Posted by psssql | 2 Comments
Wednesday, February 13, 2008 9:54 PM

How it Works: SQL Server Per Query Degree Of Parallelism Worker Count(s)

The question invoking the discussion was why did a query elect to use 100+ workers, approximately half the configured worker threads?  Before erasing this topic from my whiteboard let me document the highlights.  Often overlooked is the degree
Posted by psssql | 2 Comments
Wednesday, February 06, 2008 7:28 PM

How It Works: How does SQL Server Backup and Restore select transfer sizes

The Senior Escalation Engineers do various training and mentoring activities.  As I do this I thought I would try to propagate some of this information on the blog. A customer asked: "Why does backup to disk choose a transfer size of 1MB but
Posted by psssql | 1 Comments
Wednesday, January 23, 2008 3:28 PM

How It Works: What is Restore/Backup Doing?

The Senior Escalation Engineers do various training and mentoring activities.  As I do this I thought I would try to propagate some of this information on the blog. A customer asked: "Why does it take me 7 hours to backup my database but 21
Posted by psssql | 2 Comments
Sunday, August 19, 2007 4:46 PM

SQL Server 2005 - RDTSC Truths and Myths Discussed

I posted some updates to my blog entry about the RDTSC and drift warnings in May. See the following link http://blogs.msdn.com/psssql/archive/2006/11/27/sql-server-2005-sp2-will-introduce-new-messages-to-the-error-log-related-to-timing-activities.aspx
Posted by psssql | 4 Comments
Thursday, June 28, 2007 4:00 PM

NUMA Connection Affinity and Parallel Queries

The SQL Books Online states that using NUMA port affinity helps co-locate the resources used by the query (CPU, Memory, ….). This is true for serial plan execution but not completely the case for parallel query execution. You might assume that you can
Posted by psssql | 0 Comments
Filed under: ,
Thursday, May 31, 2007 5:15 PM

The SQL Server Working Set Message

I spent several days last week investigating reported case trends and I will attempt to summarize the findings for you. The following message was added to SQL Server 2005 SP2 to indicate that the working set (RAM resident portion of SQL Server) was paged
Posted by psssql | 8 Comments
More Posts Next page »
 
Page view tracker