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 |
|
AutumnSys
Starting Member
2 Posts |
 Posted - 2007-02-20 : 05:57:41
|
| I have a 200GB database on SQL2000 SP4 db on W2k3. Looking to improve the performance, as it was originally set up on a single data file. It's only a 2 Proc Server (but big RAID 10 Drive) so I was hoping to get some benefit from DTSing the original DB to a second DB (precreated with an MDF AND NDF now), and then repointing the front end.The DTS copy is painless and SQL Compare says it all looks good (not identical but nothing obviously going to be a problem). The problem is that now the DB is on 2 files, during the weekly DBCC REINDEX job the REINDEX sets up a BLK and then just sits there (for hours). The process is reporting A CXPACKET (waiting for the other thread) but it never clear's and moves on..This happens on 5 or 6 of the indexes, a long list of similar TSQL statements in a SQL Agent Job like this....DBCC DBREINDEX ('PolicyActionType')GO..The same code worked fine on a Single MDF database. So clearly the extra thread/paralellism is doing something !!?!?!I realise there is a load of things that I havn't mentioned here but any (polite / approriate :-) ) suggestions would be appreciated !!Charlie |
|
|
|
|
|
DBCC REINDEX CXPACKET BLOCKING