Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » Performance   (RSS)

SQL Server performance tuning methodology

Over next few posts I am going to talk about "a" methodology to do performance assessment / tuning of SQL Server based applications. Main focus will be on SQL Server engine but wherever necessary references to changes needed in application code (non T-SQL, Read More...
Posted Thursday, November 22, 2007 7:00 AM by Gaurav Bindlish | 1 Comments
Filed under:

Workload

I believe for any performance investigation you need to have a scenario. Something which is believable and real world like. In my opinion scenarios drive requirements and design. I want to have a workload which I can use to test and demonstrate various Read More...
Posted Monday, November 19, 2007 7:00 AM by Gaurav Bindlish | 1 Comments
Filed under:

Understand problem before you try to find a solution

Maoni has written a good insight on process to identify performance issues. I’ve seen enough people who looked really hard at some performance counters (often not correct ones) or some other data and asked tons of questions such as “is this allocation Read More...
Posted Monday, September 04, 2006 12:58 PM by Gaurav Bindlish | 1 Comments
Filed under:

Difference between temporary table @, #

In our internal discussion forum for SQL Server, somebody asked this question. Here is the answer (Thanks G2) Temporary tables & table variables differ in semantics, capability and query performance. Which one is appropriate for you will depend on Read More...
Posted Tuesday, March 07, 2006 8:45 AM by Gaurav Bindlish | 6 Comments
Filed under:

Graphical Representation of XML Plan

One of the biggest pain points for SQL Server 2000 was for looking at the plan of a SQL Statement, you have to execute the same. As per my understanding SQL Server 2000 did not expose any mechanism for this. So the only way to look at the plan of the Read More...
Posted Thursday, December 01, 2005 10:50 AM by Gaurav Bindlish | 1 Comments

Procedure Cache Analysis

In my previous post http://blogs.msdn.com/gauravbi/archive/2005/12/01/BufferPoolDesc.aspx we talked about analyzing the contents of buffer pool. Let's talk a bit about analyzing the contents of procedure cache- First we need to figure out what are the Read More...
Posted Thursday, December 01, 2005 10:42 AM by Gaurav Bindlish | 0 Comments

Buffer Pool Data Pages Analysis

SQL Server team has done some great amount of work in SQL Server 2005 to make the performance analysis of server easy. I am going to post a series of code snippets which I find useful in my day to day work. Memory Analysis Let us assume we have a scenario Read More...
Posted Thursday, December 01, 2005 9:53 AM by Gaurav Bindlish | 1 Comments

Improving .NET Application Performance and Scalability

http://msdn.microsoft.com/library/en-us/dnpag/html/scalenet.asp?frame=true Download from - http://www.microsoft.com/downloads/details.aspx?FamilyId=8A2E454D-F30E-4E72-B531-75384A0F1C47&displaylang=en Read More...
Posted Wednesday, August 24, 2005 10:53 AM by Gaurav Bindlish | 0 Comments
Filed under:
 
Page view tracker