Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: October 2011

Multiple query plans for the same query?

A while back i was creating a stored procedure to be used for pulling data from the SQL Server into cacti. The procedure was pulling data from a rather large table, which I had made sure was indexed properly for my query. When I executed the stored procedure from… Read more

9 comments, 4,352 reads

Posted in SQL Server Notes from the Field on 25 October 2011

When was SQL Server restarted?

One of the main goals with this blog is to write stuff when we learn / discover new things or smarter and more efficient ways to do things – and that is spot on what I’ll do today.

Finding the time when SQL Server was last restarted, and using that… Read more

0 comments, 1,087 reads

Posted in SQL Server Notes from the Field on 18 October 2011

Dude, Where is my memory?

We all know that SQL Server loves memory, and in my opinion SQL Server can never have to much RAM. RAM is faster and cheaper than IO capacity and RAM can reduce the pressure on the IO sub system.

Let’s see if we can write some diagnostic queries that can… Read more

0 comments, 351 reads

Posted in SQL Server Notes from the Field on 11 October 2011

Index usage

Last week I blogged about how to get help identifying possible missing indexes by using some of the DMV’s provided by SQL Server. This week I will show another one that can be used to see how often a given index has been used.

The DMV is this one:

select…

Read more

0 comments, 514 reads

Posted in SQL Server Notes from the Field on 4 October 2011