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 |
|
sqlserverdba
Yak Posting Veteran
53 Posts |
 Posted - 2008-12-10 : 20:41:55
|
| Hi,I've been noticing slowness in Month End processing.Please advice from where I start to diagnosis this issue? Does rebuilding the indexes help ?Thanks |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-10 : 21:06:21
|
quote:
Originally posted by sqlserverdba
Hi,I've been noticing slowness in Month End processing.Please advice from where I start to diagnosis this issue? Does rebuilding the indexes help ?It helps if indexes are fragmented and stats are out of date. How is month end processed? Thanks
|
 |
|
|
sqlserverdba
Yak Posting Veteran
53 Posts |
Posted - 2008-12-10 : 21:15:32
|
| DO you have any script for check index fragmentation and stats info? |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-10 : 21:32:33
|
| see sys.dm_db_index_physical_stats in Booksonline for details. |
|
|
|
sqlserverdba
Yak Posting Veteran
53 Posts |
Posted - 2008-12-10 : 21:59:34
|
| ANy other suggestion.thanks |
|
|
|
|
|
|
Month End processing slow