Viewing 15 posts - 1,021 through 1,035 (of 2,838 total)
Perry Whittle (4/8/2012)
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...
April 8, 2012 at 5:51 am
Perry Whittle (4/7/2012)
Stefan Krzywicki (4/7/2012)
Perry Whittle (4/7/2012)
April 7, 2012 at 9:43 pm
GilaMonster (4/7/2012)
Stefan Krzywicki (4/7/2012)
Perry Whittle (4/7/2012)
April 7, 2012 at 3:59 pm
Perry Whittle (4/7/2012)
April 7, 2012 at 3:53 pm
GilaMonster (4/7/2012)
Ok, stop the create index, try running it again with maxdop 1 specified.
OK, I'll let you know how it goes.
April 7, 2012 at 3:49 pm
GilaMonster (4/7/2012)
Stefan Krzywicki (4/7/2012)
GilaMonster (4/7/2012)
Blocking session of 0 means it's not blocked by another sessionWhat's the wait type?
CXPACKET
That's not the real wait type.
Only one row in sys.dm_exec_requests? If so check...
April 7, 2012 at 3:43 pm
I looked at the Windows System log and several times an hour I see something called the The WMI Performance Adapter service entering a running state and then a stopped...
April 7, 2012 at 3:34 pm
Perry Whittle (4/7/2012)
April 7, 2012 at 3:30 pm
GilaMonster (4/7/2012)
Blocking session of 0 means it's not blocked by another sessionWhat's the wait type?
CXPACKET
April 7, 2012 at 3:29 pm
Perry Whittle (4/7/2012)
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...
April 7, 2012 at 3:16 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:11 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:08 pm
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 happens.
I'm going...
April 7, 2012 at 3:00 pm
GilaMonster (4/7/2012)
Have you checked the windows system and application logs to make sure there...
April 7, 2012 at 1:19 pm
Perry Whittle (4/7/2012)
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?
I have...
April 7, 2012 at 1:05 pm
Viewing 15 posts - 1,021 through 1,035 (of 2,838 total)