Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 How to Monito database server Activities
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starting Member

1 Posts

Posted - 11/19/2013 :  06:57:27  Show Profile  Reply with Quote
Hi All,

I am new to DBA, i was assigned to new task i.e, our database server is too slow in between 11 am to 12 am, so i want to identify all the reasons why the database i too slow in between time, can any one please suggest me how to identify this.


Constraint Violating Yak Guru

285 Posts

Posted - 11/21/2013 :  01:57:25  Show Profile  Reply with Quote

First check which application is taking more resource in task manager. If SQL service is taking more resource then
Try to find any SQL related jobs are running in mentioned time.(If no jobs running)
Then find how may application hit occurring on SQL instance or on Database.(try to find which query is running with connections and check index related to queried Tables,..... locking, blocking...)
These are the basic things you need to investigate first.

In Love... With Me!
Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.02 seconds. Powered By: Snitz Forums 2000