Blogs

Browse by Tags

• MNSSUG
• PASS
• Performance Tuning
• SQL 2000
• SQL 2005
• SQL 2008
• SQL Tips
• SQLServerSyndication

• Querying for Parallelism

  While working on some parallelism issues today I started using the query that detects whether there are queries currently running utilizing parallelism.  It’s the same query that can be found in the white paper Troubleshooting Performance Problems Read More... Posted Wednesday, May 06, 2009 1:04 AM by Jason | 0 Comments Filed under: DM Views, SQL 2005, SQL 2008, Performance Tuning, SQLServerSyndication, SQL Tips

• Snapshots of Index Contention

  Occasionally, I need to determine where index hotspots are located within databases.  To do this, I use the DMV sys.dm_db_index_operational_stats .  I’ve talked about this DMV before while I was going through the index analysis blogs posts .  Read More... Posted Tuesday, May 05, 2009 1:52 AM by Jason | 0 Comments Filed under: DM Views, SQL 2005, SQL 2008, Performance Tuning, SQLServerSyndication, SQL Tips

• Analyze This – Analyze Your Indexes – Part 6

  This is the sixth and last for now post in which I’m going through a query that can be used to analyze indexes.  Thus far the following has been added to the query: Combine existing index statistics and missing indexes into a single output ( blog Read More... Posted Wednesday, April 29, 2009 8:00 AM by Jason | 1 Comments Filed under: DM Views, SQL 2005, SQL 2008, Performance Tuning, SQLServerSyndication, SQL Tips

• Analyze This – Analyze Your Indexes – Part 5

  This is the fifth post in which I am walking through a query that I use to analyze indexes.  Thus far I have added to the following to the query that I use: Combine existing index statistics and missing indexes into a single output ( blog ) Find Read More... Posted Tuesday, April 28, 2009 8:00 AM by Jason | 1 Comments Filed under: DM Views, SQL 2005, SQL 2008, Performance Tuning, SQLServerSyndication, SQL Tips

• Find Query Plans That May Utilize Parallelism

  When ever I go to a new client to assist with performance issues, I inevitably download the Troubleshooting Performance Problems in SLQ Server 2005 white paper.  In my opinion and many others, it is one of those documents that should be at the click Read More... Posted Monday, April 27, 2009 8:58 PM by Jason | 0 Comments Filed under: DM Views, SQL 2005, SQL 2008, Performance Tuning, SQLServerSyndication

• Analyze This – Analyze Your Indexes – Part 4

  This is the fourth post in which I am walking through a query that I use to analyze indexes.  Thus far I have added to the following to the query that I use: Combine existing index statistics and missing indexes into a single output ( blog ) Find Read More... Posted Thursday, April 23, 2009 5:43 PM by Jason | 0 Comments Filed under: DM Views, SQL 2005, SQL 2008, Performance Tuning, SQLServerSyndication, SQL Tips

• What is the size of your index?

  I got the following question a couple days ago: “I have one problem with my database. The size of mdf file is huge and i feel it is not the data that is causing the increase in size, i feel indexes might be occupying space.  Is there any way to find Read More... Posted Thursday, April 23, 2009 4:04 PM by Jason | 0 Comments Filed under: DM Views, SQL 2005, SQL 2008, SQLServerSyndication

• PASS MN – Drive Your Way to the DMV

  The Minnesota SQL Server User Group ( http://www.mnssug.org ) met this past Tuesday.  It was a good crowd for a beautiful Tuesday afternoon – there were 57 people at the meeting at the mid-point. I spoke in the first time slot and think people enjoyed Read More... Posted Thursday, April 23, 2009 9:20 AM by Jason | 0 Comments Filed under: DM Views, SQL 2008, SQL 2000, MNSSUG

• Analyze This – Analyze Your Indexes – Part 3

  This is the third post in which I am walking through a query that I use to analyze indexes.  Thus far I have added to the following to the query that I use: Combine existing index statistics and missing indexes into a single output ( blog ) Find Read More... Posted Tuesday, April 21, 2009 9:15 AM by Jason | 1 Comments Filed under: DM Views, SQL 2008, SQL 2000, Performance Tuning, SQLServerSyndication, SQL Tips

• Tonight April PASSMN Meeting (04/21/2009)

  Looking for something fun to do?  Trying to get your SQL Server to perform a little better? There is a PASSMN (Minnesota SQL Server User Group) meeting tonight.  We are meeting a little later than usual because of a room conflict.  Instead Read More... Posted Tuesday, April 21, 2009 9:00 AM by Jason | 0 Comments Filed under: DM Views, SQL 2005, SQL 2008, MNSSUG, Performance Tuning, SQLServerSyndication, PASS

• Analyze This – Analyze Your Indexes – Part 2

  This is the second post in which I am walking through a query that I use to analyze indexes.  For some reason the grammar on the title of the first post was a bit jacked so I’ve corrected it for this post and the all following ones. Here’s a summary Read More... Posted Monday, April 20, 2009 8:59 AM by Jason | 6 Comments Filed under: DM Views, SQL 2005, SQL 2008, Performance Tuning, SQLServerSyndication, SQL Tips

• Analyze This – Your Indexes Analysis – Part 1

  Shrinks have no idea what’s wrong with you when you walk in the door.  In you come you try to describe what appears to be the problem and then they start asking about your mother.  But you don’t want to talk about your mother, most likely you’d Read More... Posted Sunday, April 19, 2009 3:01 AM by Jason | 3 Comments Filed under: DM Views, SQL 2005, SQL 2008, Performance Tuning, SQLServerSyndication, SQL Tips

• Next Tuesday April PASSMN Meeting (04/21/2009)

  Don’t forget this coming Tuesday is the next PASSMN (Minnesota SQL Server User Group) meeting.  We are meeting a little later than usual because of a room conflict.  Instead of starting the meeting at 2:30 PM we are meeting at 4:30 PM. We have Read More... Posted Saturday, April 18, 2009 9:00 AM by Jason | 0 Comments Filed under: DM Views, MNSSUG, Performance Tuning, SQLServerSyndication, PASS

• Monitoring Index Contention With DMFs

  Often when I am load testing an application with a client I want to check to see if there is any index contention in a database.  To do this, I use the DMF sys.dm_db_index_operational_stats .  For a good rundown on this DMF, I recommend reading Read More... Posted Wednesday, February 25, 2009 9:24 AM by Jason | 0 Comments Filed under: DM Views, SQL 2005, SQL 2008, Performance Tuning, SQLServerSyndication

• DMV Version of sp_who2

  I put together a presentation on Dynamic Management Views (DMVs) a few months back and one of queries I put together for that presentation was a version of sp_who2 that provided similar results but used DMVs instead. The query has most of the same  Read More... Posted Wednesday, February 04, 2009 8:22 AM by Jason | 0 Comments Filed under: DM Views, SQL 2005, SQL 2008, SQLServerSyndication