April 10, 2008 at 2:44 am
Please could someone tell me what I could expect to see in sysprocesses if a reindex is in progress?
Many thanks
April 10, 2008 at 2:51 am
Assuming you're using the ALTER INDEX command, which you should be you'll see ALTER INDEX in the cmd column. I assume that was the column you were interested in. Status column will be runnable, open_tran column will be 1.
April 10, 2008 at 2:55 am
Hello,
Thanks for your reply. I need to check for both 2005 and 2000 databases. So should I chack for "Alter Index" and "DBCC reindex"?
April 10, 2008 at 3:04 am
Rootman (4/10/2008)
Hello,Thanks for your reply. I need to check for both 2005 and 2000 databases. So should I chack for "Alter Index" and "DBCC reindex"?
I'm not sure what it is on SQL 2000 and I don't have access to a SQL 2000 box to check. But running dbcc dbreindex on SQL 2005 shows DBCC in the cmd column of sysprocesses.
Easiest way to be sure though is for you to check. Just run a dbcc dbreindex command on test machine (or even your own workstation, using AdventureWorks) and then do a select * from sysprocesses where spid = from another query window.
April 11, 2008 at 2:37 am
In Sql 2000 also it will show DBCC only in the cmd column when you run DBCC Reindex.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply