Home > IT Blogs > The Multifunctioning DBA/

The Multifunctioning DBA:

Indexing

1
November 25, 2011  9:00 PM

Another Index to save the day



Posted by: Colin Smith
Indexing

I had a customer call and complain that a select distinct statement was taking over 10 minutes to run and they thought that was to long. The table they are running the query against does have over 600 million rows so it is not a small table but it is partitioned. So I started looking into it and I...

  Bookmark and Share     0 Comments     RSS Feed     Email a friend

October 2, 2011  3:23 PM

Just a little Index



Posted by: Colin Smith
Indexing, Performance, Tuning

I ran into a SQL Server that was performing poorly and when I looked at it the only metric that looked like it was causing an issue was the CPU at about 95% avg. I Ran the below query to check and see what my top CPU consumers on the system were. It also showed me that they were executed a...

  Bookmark and Share     0 Comments     RSS Feed     Email a friend

1