Viewing 15 posts - 41,461 through 41,475 (of 49,562 total)
ashepard (1/23/2009)
So does that mean the disk should be formatted for 8k sector size?
No.
There's lots of info on IO config for SQL. Google should find them for...
January 24, 2009 at 1:20 am
Is there any blocking?
Has the volumes of data changed?
Are your indexes defragmented and your stats up to date?
January 24, 2009 at 1:18 am
Ed (1/23/2009)
Thanks for your help. I'm using Toad for SQL Server, so hopefully this is the format you're looking for.
No. I was looking for the exec plan that management...
January 23, 2009 at 2:38 pm
kwiggans (1/23/2009)
January 23, 2009 at 2:27 pm
Marios Philippopoulos (1/23/2009)
There is a risk that the data from the DMV dm_exec_query_stats is regularly flushed from memory if there is memory pressure in your system.
There's a couple other...
January 23, 2009 at 2:23 pm
KATHLEEN Y ZHANG (1/23/2009)
I hope running trace as a background job is much less intrusive.
It is. Grant explained why - http://scarydba.wordpress.com/2008/12/18/profiler-research/
January 23, 2009 at 2:14 pm
Ellen (1/23/2009)
January 23, 2009 at 2:07 pm
Ed (1/23/2009)
So even if 20 coded columns need to access the lookup table to decode to descriptions, a table scan will be performed 20 times?
Not sure what you're...
January 23, 2009 at 2:06 pm
Few questions.
Why is the tran log set up as 4 files?
Are the log files on a separate physical drive from the data files?
Likewise, is the drive that the log backups...
January 23, 2009 at 1:28 pm
ashepard (1/23/2009)
If you are working with short rows, like a domian table of values then...
January 23, 2009 at 1:26 pm
See here - http://sqlinthewild.co.za/index.php/2009/01/09/seek-or-scan/
Edit: don't use index hints unless you are really sure you know what they're doing and why the optimiser didn't pick that index itself.
January 23, 2009 at 1:07 pm
Grant Fritchey (1/23/2009)
I haven't run averages on my systems recently, but 20ms just for recompiles seems a bit high for an average.
The 20 is compiles/sec, not sec/compile. There's no counter...
January 23, 2009 at 12:58 pm
Keena Ferguson (1/23/2009)
You are correct ... I only copied the first few lines ... I have attached the entire results set ... I have been looking at the DBCC CHECKDB...
January 23, 2009 at 12:47 pm
Is that the full output from CheckDB? It doesn't look like it. Can you please the full output. (If it's large, save it to a text file, zip and attach)
January 23, 2009 at 1:06 am
Viewing 15 posts - 41,461 through 41,475 (of 49,562 total)