Viewing 15 posts - 13,081 through 13,095 (of 22,215 total)
OLDCHAPPY (3/8/2011)
for the 3rd time...IT WON'T ACCEPT DECIMAL VALUES. :crazy:and 95% is simply an example value. it's just an easy value to make the server hit to test alerts.
Not...
March 8, 2011 at 9:14 am
OLDCHAPPY (3/8/2011)
March 8, 2011 at 8:45 am
Basically you just asked it to create a new execution plan. If this is a seldom called, complex, long-running query, paying the cost for compiling a new plan, especially since...
March 8, 2011 at 8:22 am
Abhijit More (3/8/2011)
March 8, 2011 at 8:13 am
For the buffer cache hit ratio, set it to 95 if you want to know when it hits below that number (although, if you ask me, that's a very high...
March 8, 2011 at 5:34 am
soufya91 (3/8/2011)
for ex: what is scheme used for and what are...
March 8, 2011 at 5:26 am
SLEEP_TASK means it's waiting for some generic task to clear before it continues. This means it's waiting on the lazy writer or something like that. Is this process causing blocking...
March 8, 2011 at 5:17 am
3. Yes, dropping a procedure also removes the plan from cache (well, marks it, it'll get removed later), so when you rebuild the proc, you get a new plan.
I just...
March 8, 2011 at 5:12 am
Yep, do what Gail says. Actually, that's a safe bet in general.
March 8, 2011 at 5:09 am
No, I haven't seen issues with that DMV before. When it's running long, take a look at sys.dm_exec_requests or sys.dm_os_waiting_tasks to see what is causing it to slow down.
March 7, 2011 at 2:45 pm
You just have to attack it a step at a time. Generally, gathering metrics on the system, general performance metrics, and wait states is the best beginning (after setting up...
March 7, 2011 at 2:34 pm
Honestly, that's a bad approach and will lead to problems. Best to let SQL Server handle locking for you. It will absolutely handle it well. If you have to, set...
March 7, 2011 at 2:30 pm
Absolutely sounds like parameter sniffing gone wrong.
March 7, 2011 at 2:23 pm
1) it really depends on what you're looking for. Basically it seems OK. I'm not sure I'd have the outer BEGIN...END wrapper because it's not really doing anything for you,...
March 7, 2011 at 2:23 pm
It's hard to know exactly what it might be based on the information at hand. Have you looked at the DMV sys.dm_os_waiting_tasks? You can combine this with other DMVs such...
March 7, 2011 at 2:17 pm
Viewing 15 posts - 13,081 through 13,095 (of 22,215 total)