Viewing 15 posts - 11,746 through 11,760 (of 22,214 total)
If the CPU is 100%, I'd focus there, not on memory. Memory pressure can evidence itself with increased I/O as more stuff gets flushed to disk more frequently, but it's...
October 5, 2011 at 7:47 am
From what you're saying, it's dynamic. You won't be able to create a plan guide for it. Modify the text and put in hints directly or take away the dynamic...
October 5, 2011 at 7:42 am
Scans aren't necessarily bad and seeks aren't necessarily good. It really depends on their relationship to the rest of the process, the number of rows involved, joins associated... It's actually...
October 5, 2011 at 7:35 am
But then you build the system to allow the drill-down to make another query. I've been through this too, at multiple organizations with multiple different data sets. There are any...
October 4, 2011 at 12:19 pm
Absolutely. It's like an on/off switch. Put a clustered index on the table, and the table becomes the clustered index. Without a clustered index, the table is a heap. That's...
October 4, 2011 at 8:19 am
Ninja's_RGR'us (10/4/2011)
solomon.jernas (10/4/2011)
For reporting purpose, but all connection are suspended stauts, ather application getting time out issue web page,Thanks
Why don't you return the sum (or what ever aggregate) the...
October 4, 2011 at 6:49 am
You're returning a million records in a minute? Sounds like performance is OK. Why are you returning a million records?
October 4, 2011 at 4:24 am
parsayandan (10/3/2011)
and If your think was true I delete SCC data or data that have problem...
October 3, 2011 at 4:59 pm
Stefan Krzywicki (10/3/2011)
Grant Fritchey (10/3/2011)
October 3, 2011 at 11:58 am
No contact links anywhere on that EMC blog. So I went to the EMC site, the contact us link is prominent, but you get a 404 error (and not a...
October 3, 2011 at 11:08 am
WayneS (10/3/2011)
Grant Fritchey (9/28/2011)
WayneS (9/28/2011)
Grant Fritchey (9/28/2011)
Jack Corbett (9/28/2011)
October 3, 2011 at 9:52 am
Mr. Holio (10/3/2011)
Thanks.So when do do you usually look at the time stats if it is "not a way of measuring performance at all" ? Thank you.
I probably wasn't...
October 3, 2011 at 5:00 am
Then the restore is not complete. It's still rolling forward or rolling back transactions to finish up. That, or your backup processes had NORECOVERY set, in which you case you...
October 2, 2011 at 6:43 am
Viewing 15 posts - 11,746 through 11,760 (of 22,214 total)