Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
vganeshkumar08
Starting Member
1 Post |
 Posted - 2013-11-19 : 06:57:27
|
| 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.ThanksGanesh |
|
|
raghuveer125
Constraint Violating Yak Guru
285 Posts |
Posted - 2013-11-21 : 01:57:25
|
| Hi,First check which application is taking more resource in task manager. If SQL service is taking more resource thenTry 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! |
 |
|
|
|
|
|
How to Monito database server Activities