Viewing 15 posts - 2,341 through 2,355 (of 18,926 total)
Hmm... can you post the full statement? I think I know what you're having problems with.
Reading this is not a bad idea (just to know it exists)
http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries
September 23, 2011 at 7:29 am
Netic (9/23/2011)
The size of the "touched" tables aren't the same during morning and night right ? 🙂
Maybe not but right now I'm assuming constant growth with varying speed, but without...
September 23, 2011 at 7:27 am
Ratheesh.K.Nair (9/23/2011)
It is like everyday morning the query executes in seconds and in afternoon its taking...
September 23, 2011 at 7:26 am
That's one of the limits of plans. Anything done remotely comes back as one black box general step, usually with super high %.
The only way to debug is to...
September 23, 2011 at 7:19 am
It's always useful. Lots of traffic come in here from google.
September 23, 2011 at 6:50 am
Netic (9/23/2011)
Are you aware of "huge" data modifications? If they exists, update statistics should be run 🙂Regards,
Paulo Condeça.
The plan would answer that question ;-).
September 23, 2011 at 6:49 am
Ratheesh.K.Nair (9/23/2011)
Thanks for the Reply ninja.Its teh same query executing morning and afternoon
Please post both. The slow & fast version.
There's important info in those.
September 23, 2011 at 6:44 am
Gianluca Sartori (9/23/2011)
GilaMonster (9/23/2011)
Task manager is a terrible way to check SQL's memory. It's incorrect in many cases (yes, there is a reason, it's not a bug)
Thank you for the...
September 23, 2011 at 6:18 am
adb2303 (9/23/2011)
there might be a cheeky 256GB in that host 😎Points taken though... thanks
And only 1 DB :w00t:???
September 23, 2011 at 6:12 am
Nice san & ram ;-).
Or 1 hell of a wide table.
The problem with it is that you can basically flush out the entire data cache. Slowing everything else way...
September 23, 2011 at 6:04 am
adb2303 (9/23/2011)
if all you want is row counts, you could use:
exec sp_MSforeachtable 'select count(*), ''?'' as table_name from ?'
Gonna be slow as hell to run.
Try that code on a small...
September 23, 2011 at 5:57 am
That's what I get for always patching my servers :-D.
September 23, 2011 at 5:31 am
yes.
Then copy the statemenet sent to the server in ssms and debug that. You'll figure out what to do next ;-).
September 23, 2011 at 5:31 am
chandan_jha18 (9/22/2011)
Ninja's_RGR'us (9/22/2011)
Sounds like I'd do a sp for each report they need.
I'd also look at some sort of replication,...
September 23, 2011 at 5:30 am
First guess => http://sqlinthewild.co.za/index.php/2011/03/22/statistics-row-estimations-and-the-ascending-date-column
If that doesn't help, post the actual execution plan. Ideally the one when it's good and the bad one too.
September 23, 2011 at 5:27 am
Viewing 15 posts - 2,341 through 2,355 (of 18,926 total)