Viewing 15 posts - 12,646 through 12,660 (of 22,214 total)
Ninja's_RGR'us (4/26/2011)
So plan B would be? Collect a trace and sum up to reads / writes columns?
I think I'd call it step 2 of Plan A, but yeah.
April 26, 2011 at 6:51 am
Ninja's_RGR'us (4/26/2011)
Grant Fritchey (4/26/2011)
Ninja's_RGR'us (4/26/2011)
Grant Fritchey (4/26/2011)
You need a fundamental assessment of the system...
April 26, 2011 at 6:26 am
Ninja's_RGR'us (4/26/2011)
Grant Fritchey (4/26/2011)
You need a fundamental assessment of the system done. It sounds...
April 26, 2011 at 6:17 am
I would look first at the SQL Server error log. You can see that in the Management folder in SSMS. I would also look at the Event Viewer on the...
April 26, 2011 at 6:03 am
Referential integrity is also a speed issue. It speeds things up. Here's a blog post outlining why[/url].
You need a fundamental assessment of the system done. It sounds like you don't...
April 26, 2011 at 6:00 am
Absolutely possible. Pretty common task really. It's an easy way to get a database from one system to another. When you run the restore operation you'll probably have to use...
April 26, 2011 at 5:56 am
Without knowing lots more about your system, there's no way to know why it's running longer. It could be parameter sniffing. It could be blocking. It could be a hundred...
April 26, 2011 at 5:54 am
nico van niekerk (4/26/2011)
April 26, 2011 at 5:45 am
I have to say, after almost 3 months of working from home, I'm still not used to it. However, I love it. I'm getting tons of work done. I get...
April 26, 2011 at 5:39 am
David Burrows (4/25/2011)
Grant Fritchey (4/25/2011)
... I usually bump mine up to 35 or so on OLTP systems.Is that a general rule of thumb?
Are there any consequences to that setting?
Not really....
April 25, 2011 at 8:35 am
I only know of one person who went straight from college to a full-time DBA and he spent about 18 months as an unpaid intern first. Since you have zero...
April 25, 2011 at 5:14 am
In addition to everything else already mentioned, make sure you have good statistics maintenance running on the table. They will impact the plans chosen and because of that, the time...
April 25, 2011 at 5:08 am
On the other hand, if you're looking at the text showplan, you'll need to parse it using some other language. Better to get the XML plan.
April 25, 2011 at 5:02 am
On a side note, I'd suggest taking your cost threshold for parallelism to a much higher number. It looks like it's at the default of 5. I usually bump mine...
April 25, 2011 at 5:00 am
It does sound like bad parameter sniffing. In addition to recompile for the procedure, you can try recompile for the problematic statement within the procedure. Recompiles can be expensive, so...
April 25, 2011 at 4:58 am
Viewing 15 posts - 12,646 through 12,660 (of 22,214 total)