Viewing 15 posts - 41,716 through 41,730 (of 49,571 total)
-- Cranfield (1/15/2009)
Array Controller in slot 1.
This may result in a "downshift" in transfer rate...
January 15, 2009 at 8:42 am
Sandra Skaar (1/15/2009)
Avg. Disk sec/Write: Last(.001), Average(.252), Minimum (0.000), Maximum(2.500)Avg. Disk sec/Read: Last(.000), Average(.020), Minimum (0.534), Maximum(11.141)
That is bad!
The sec/read and sec/write should be below 10ms. You've got...
January 15, 2009 at 8:32 am
RBarryYoung (1/15/2009)
Can you use those Plan Guide thingys? Or do you need something more stable for that?
That's exactly what we're looking at.
January 15, 2009 at 8:29 am
SQLH (1/15/2009)
Would this setup gain performance from having does logical drive setup? Why or why not?
No. It's still the same physical drive. It may even decrease performance by requiring the...
January 15, 2009 at 8:24 am
Is it blocked by another query? Is there a wait type, and if so, what is it? (check sysprocesses)
Are there any entries in the error log? That sometimes happens when...
January 15, 2009 at 8:22 am
Chris Morris (1/15/2009)
January 15, 2009 at 8:16 am
By rebuilding the index you have updated statistics and removed fragmentation. Both can make SQL pick an index it previously ignored. My bet's on the statistics.
January 15, 2009 at 8:07 am
There's nothing there that makes any sense and certainly nothing that points to a cause for a deadlock. I've never heard of a deadlock on a communication buffer before.
Maybe give...
January 15, 2009 at 8:00 am
Kent Waldrop (1/15/2009)
And veto power can stop many problems before they ever happen.
I officially had veto rights at my last company. I say officially, because the CIO tended...
January 15, 2009 at 7:58 am
Jeff Moden (1/15/2009)
January 15, 2009 at 7:25 am
So the drive was accessible when SQL started, but something happened a little later. Can you check the windows event log around the same time as the latch errors started?...
January 15, 2009 at 7:14 am
GSquared (1/15/2009)
Sounds like quite a nice collection. All I have is handguns, and none of them are particularly pretty (functional, but not quite so aesthetic).
Grant Fritchey (1/15/2009)
January 15, 2009 at 6:55 am
Grant Fritchey (1/15/2009)
For example, oh Gail, how many swords in your house?
Only one at the moment. I'm considering buying a basket-hilt rapier (local weapons shop has a nice ornamental...
January 15, 2009 at 6:41 am
Kent Waldrop (1/15/2009)
I would say that biggest source of the problems that I've seen over the years are design problems.
Agreed. I'm in the middle of a wonderful one now.
Rather...
January 15, 2009 at 6:34 am
-- Cranfield (1/15/2009)
I was thinking of renaming the files, dropping the database and then atttempting to attach the files.
No! Absolutely not. If you do that, there's a good chance...
January 15, 2009 at 6:21 am
Viewing 15 posts - 41,716 through 41,730 (of 49,571 total)