It’s quite often at clients that I spend time working on issues revolving around parallelism. In fact, just this week it’s been the single most irritating performance problem that I've had to deal with. If you aren’t up to snuff on parallelism there are a couple places I would start with getting up to speed: … Continue reading Learning More About Parallelism
Ever have a Reporting Services (SSRS) subscription that didn’t fire off as you thought it should? Or was SQL Agent offline when subscriptions should have been fired? Or did you just create a subscription and want to find out if it’s been configured properly? Fortunately all of the information is sitting neatly and plainly in … Continue reading I Didn’t Receive My Subscription
A while back I was asked to identify schemas that didn’t have any objects. Since it was a useful query, I thought I’d share it.
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 in SQL Server 2005. Which I’ve included below: The information that I like to have on hand is … Continue reading Querying for Parallelism
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. This DMV returns locking and blocking information for tables and indexes in the database. This information is aggregated since … Continue reading Snapshots of Index Contention
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 Find existing duplicate and overlapping indexes Find the relationship between indexes … Continue reading Analyze This – Analyze Your Indexes – Part 6
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 Find existing duplicate and overlapping indexes Find the relationship between indexes … Continue reading Analyze This – Analyze Your Indexes – Part 5
When ever I go to a new client to assist with performance issues, I inevitably download the Troubleshooting Performance Problems in SQL Server 2005 white paper. In my opinion and many others, it is one of those documents that should be at the click of a button to open and I keep it handy on … Continue reading Find Query Plans That May Utilize Parallelism
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 Find existing duplicate and overlapping indexes Find the relationship between indexes … Continue reading Analyze This – Analyze Your Indexes – Part 4
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 that indexes are occupying … Continue reading What is the size of your index?
Strate SQL 