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 |
|
kbk
Starting Member
34 Posts |
 Posted - 2009-03-12 : 11:39:14
|
| can update statistics job run in off peak hours cause high cpu?if so,what is the solution?bk |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2009-03-12 : 15:02:41
|
| It will not block the tables but can cause CPU spikes.. are you running script in one batch or have multiple steps for each table etc? If you have it as a batch, perhaps you can split them up into multiple jobs and run them in parallel.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
kbk
Starting Member
34 Posts |
Posted - 2009-03-12 : 15:18:15
|
| its a batch process.separate job for seperate databasebk |
|
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2009-03-13 : 12:06:15
|
| Like I said I would split the batch process into multiple jobs and spread the tables into the jobs...you will be done faster..Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
|
|
|
|
|
|
update statistics