Viewing 15 posts - 11,266 through 11,280 (of 22,219 total)
You can also see the compile time values in the execution plan itself. Always check the first operator (SELECT for a query, INSERT/UPDATE/DELETE, as appropriate). That shows compile time parameter...
"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
February 15, 2012 at 5:21 am
If you click on the Deadlock Alert in SQL Monitor it should bring up a window that has the basic deadlock information in it.
You can see the victim and...
"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
February 15, 2012 at 4:42 am
I wouldn't modify anything until the migration was done and successfully implemented.
"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
February 14, 2012 at 12:43 pm
Absolutely use the Upgrade advisor as Jeff says. That has to be step 1. If it identifies issues, address them first.
Run a backup. You want to be absolutely safe during...
"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
February 14, 2012 at 5:08 am
Even the new AlwaysOn capabilities with SQL Server 2012 that include asynchronous updates are still just mirrors of the main database, not historical beyond the delay of the asynchronous updates....
"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
February 13, 2012 at 7:30 am
GilaMonster (2/13/2012)
Dev (2/13/2012)
Just for clarity, what do you mean by "duplicating database is beter than taking backups"?Hot / Warm standby servers.
Those are HA/DR, not backups. They're great...
"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
February 13, 2012 at 7:06 am
Try using OR in the WHERE clause. See what happens then.
"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
February 13, 2012 at 6:04 am
Blocking is a part of the process of the system. You need to define your transactions such that they are as small and as short as possible. Tune the queries,...
"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
February 13, 2012 at 5:12 am
Worth pointing out, if you have some money to spend, another way around this issue is to look at a third party tool like Red Gate Virtual Restore[/url]. It allows...
"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
February 12, 2012 at 7:21 am
Dev (2/12/2012)
"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
February 12, 2012 at 7:14 am
Yes, querying the missing index information from the cache is a useful starting point, but it's just that. Unfortunately, there are no good tools for auto-tuning databases. The Tuning Advisor...
"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
February 10, 2012 at 12:32 pm
GilaMonster (2/10/2012)
pdanes (2/10/2012)
"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
February 10, 2012 at 12:29 pm
Steve Jones - SSC Editor (2/10/2012)
Worth the read: http://www.newyorker.com/reporting/2011/10/03/111003fa_fact_gawande
Absolutely. I enjoyed that one a lot.
BTW, since you guys have no doubt stopped laughing over my applying to the mentor program,...
"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
February 10, 2012 at 12:28 pm
If you don't have access to the report that has all the information, then you must have a traceflag enabled on the server so that the deadlock goes to the...
"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
February 10, 2012 at 12:22 pm
Boy does that sound like an interview question.
Let's assume it is, the answer you give has to basically be, how do you decide if it's a DBA problem or 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
February 10, 2012 at 12:20 pm
Viewing 15 posts - 11,266 through 11,280 (of 22,219 total)