Viewing 15 posts - 13,081 through 13,095 (of 22,219 total)
We've been using it quite a while with no issues. I suppose it's remotely possible that you could mixed data if you had a lot of transactions all trying to...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 9, 2011 at 8:12 am
In general, the way you can tell something is parameter sniffing is not simply if it runs faster or slower, that could be contention or any number of other things....
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 9, 2011 at 8:05 am
BeginnerBug (3/9/2011)
Thanks fritchey.....
It's Grant, and you're welcome.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 9, 2011 at 6:52 am
Beyond validating connectivity and running the DBCC checks, no, there's nothing to do at the database level.
As far as the server goes, you're going to want to migrate all your...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 8, 2011 at 9:17 am
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 8, 2011 at 9:14 am
OLDCHAPPY (3/8/2011)
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 8, 2011 at 8:22 am
Abhijit More (3/8/2011)
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 8, 2011 at 5:34 am
soufya91 (3/8/2011)
for ex: what is scheme used for and what are...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 8, 2011 at 5:12 am
Yep, do what Gail says. Actually, that's a safe bet in general.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 7, 2011 at 2:34 pm
Viewing 15 posts - 13,081 through 13,095 (of 22,219 total)