Viewing 15 posts - 5,761 through 5,775 (of 9,253 total)
Stefan Krzywicki (4/7/2012)
The creation of the index you suggested did complete after 2 hours. That's much slower than it should be, but at least it completed.
Ok the index i suggested...
April 8, 2012 at 3:07 am
You could capture the failovermgr events in the windows system log and also check the windows application log for concurrent event messages.
April 7, 2012 at 5:26 pm
Stefan Krzywicki (4/7/2012)
Perry Whittle (4/7/2012)
April 7, 2012 at 4:03 pm
Unfortunately I can't supply you a query as I'm not at my computer. As Gail said kill the current session id for the create index and re run with maxdop...
April 7, 2012 at 3:51 pm
Stefan Krzywicki (4/7/2012)
I'm not going to be able to take the database offline until tomorrow..
Don't worry not necessary
You need to find the actual wait type. There should be multiple threads...
April 7, 2012 at 3:40 pm
GilaMonster (4/7/2012)
Blocking session of 0 means it's not blocked by another sessionWhat's the wait type?
Doh totally misread that one lol
April 7, 2012 at 3:37 pm
Ok so there is something blocking the operation, strange. Can you force the database offline using rollback immediate then bring it back online and after about 15 mins re run...
April 7, 2012 at 3:23 pm
Perry Whittle (4/7/2012)
Stefan Krzywicki (4/7/2012)
Perry Whittle (4/7/2012)
Run this and let me know what happens
CREATE NONCLUSTERED INDEX NoddyIDX ON dbo.FTD
(ProdID ASC)
Same problem as the main index. Runs for over an hour...
April 7, 2012 at 3:12 pm
Stefan Krzywicki (4/7/2012)
Perry Whittle (4/7/2012)
Run this and let me know what happens
CREATE NONCLUSTERED INDEX NoddyIDX ON dbo.FTD
(ProdID ASC)
Same problem as the main index. Runs for over an hour and nothing...
April 7, 2012 at 3:05 pm
Welsh Corgi (4/7/2012)
I could not eve log on so I removed SQL Server 2008 R2.
Why didn't you just put it single user mode and add the appropriate account into sysadmins?
April 7, 2012 at 1:46 pm
Run this and let me know what happens
CREATE NONCLUSTERED INDEX NoddyIDX ON dbo.FTD
(ProdID ASC)
April 7, 2012 at 1:26 pm
Before going any further I would like you to confirm exactly the configuration of the logical disks, also is this server a virtual machine by any chance?
April 7, 2012 at 1:03 pm
Stefan Krzywicki (4/7/2012)
I'm sorry, I don't know how to answer that question.You mean other than each of those being a different physical drive?
Yes, exactly. Get your server admin to confirm...
April 7, 2012 at 12:49 pm
Stefan Krzywicki (4/7/2012)
Well, I had been running the index creation with WITH SORT_IN_TEMPDB = ON, so wouldn't the sort space be happening on C?
Yes it would hit C drive
April 7, 2012 at 12:46 pm
Stefan Krzywicki (4/7/2012)
Perry Whittle (4/7/2012)
Other things to considerHow many logical drives are you using?
What are the physical disk configs underneath these?
System dbs on C
log files on G
data files on...
April 7, 2012 at 12:42 pm
Viewing 15 posts - 5,761 through 5,775 (of 9,253 total)