Viewing 15 posts - 12,436 through 12,450 (of 22,214 total)
Performance tuning is a large topic. Gail Shaw has some excellent articles[/url] on Simple-Talk. I'd start there. Once you've got those under your belt, pick up a copy of my...
May 28, 2011 at 4:09 am
So don't use sp_who2. That's the old approach anyway. Dive into the DMOs and get lots of good information.sys.dm_exec_requests will show you what's currently running. You can combine that with...
May 28, 2011 at 4:06 am
Roy Ernest (5/27/2011)
WayneS (5/27/2011)
GilaMonster (5/27/2011)
Precon and spotlight! Could this PASS Summit get any better?So, you're aiming for a keynote address now?
Along with Dr DeWitte
She'll probably start correcting him.
May 27, 2011 at 3:27 pm
Your trigger needs to be on the child table and it needs to say "UPDATE Parentable..." in order for the parent table to be updated.
May 27, 2011 at 6:19 am
Modify the procedure that updates the child table so that it also updates the parent table. That'd be my first approach. You could also look at setting up a trigger...
May 27, 2011 at 5:55 am
I'd check the execution plans. Something has to be changing there. I'm not a fan of cross-database queries anyway.
May 27, 2011 at 4:43 am
Especially on a reporting system I would not suggest ditching parallelism. Usually reporting systems get the most help from parallelism.
However, if you've done the research and you're getting excessive waits...
May 27, 2011 at 4:36 am
You have to do the hard slog. Gather performance metrics, capture wait stats, get the longest running and most frequently called queries, then start addressing the issues. There are extremely...
May 27, 2011 at 4:33 am
Everyone has hit a lot of the highlights, I especially like checking the SELECT operator properties to see the compile & runtime values on params & the reason for early...
May 27, 2011 at 4:25 am
Fraggle-805517 (5/26/2011)
Grant Fritchey (5/26/2011)
You're still guaranteed a recompile each time a temp table is created and first referenced.
Grant,
I understand that I will get recompile each time a temp table is...
May 26, 2011 at 1:36 pm
Brandie Tarvin (5/26/2011)
Grant Fritchey (5/26/2011)
Brandie Tarvin (5/26/2011)
May 26, 2011 at 1:32 pm
Fraggle-805517 (5/26/2011)
Grant Fritchey (5/26/2011)
You're still guaranteed a recompile each time a temp table is created and first referenced.
Grant,
I understand that I will get recompile each time a temp table is...
May 26, 2011 at 1:32 pm
Brandie Tarvin (5/26/2011)
I'm not...
May 26, 2011 at 11:53 am
GilaMonster (5/26/2011)
One very uncomfortable PM sent...From the posts the person has made, they are totally out of their depth. 6TB DBs, major perf problems and barely a clue.
How do people...
May 26, 2011 at 9:39 am
Roy Ernest (5/26/2011)
Gianluca Sartori (5/26/2011)
Brandie Tarvin (5/26/2011)
GilaMonster (5/26/2011)
Roy Ernest (5/26/2011)
May 26, 2011 at 9:37 am
Viewing 15 posts - 12,436 through 12,450 (of 22,214 total)