CREATE DATABASE

Quest in Database design

Browse by Tags

Tagged Content List
  • Blog Post: 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, non schema based, non configuration options...
  • Blog Post: 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 capabilities of SQL Server database. Why I am doing...
  • Blog Post: 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 rate too high? It looks too high to me.” or “my gen1...
  • Blog Post: 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 your circumstances. Temporary table operations...
  • Blog Post: 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 query was to capture the queries used by application...
  • Blog Post: 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 plans present in the cache after a scenario...
  • Blog Post: 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 which executes a bunch of queries. For...
  • Blog Post: 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
Page 1 of 1 (8 items)