SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

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

vganeshkumar08
Starting Member

India
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.

Thanks
Ganesh

raghuveer125
Constraint Violating Yak Guru

India
285 Posts

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

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  
 New 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.03 seconds. Powered By: Snitz Forums 2000