Viewing 15 posts - 8,686 through 8,700 (of 22,219 total)
The basic costs break down on the parsing of the query and/or getting the object id of the procedure and then retrieving those from cache by a search on 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
March 13, 2014 at 6:58 am
You said variables several times. Be sure to differentiate between variables and parameters. A parameter, defined with the stored procedure or in a parameterized query, can be sampled, or sniffed,...
"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 13, 2014 at 6:41 am
You can gather information on deadlocks on SQL Server 2008 and better without ever setting a trace flag. Just use the system_health extended event session that is running automatically on...
"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 13, 2014 at 6:37 am
I'd suggest breaking up your index rebuilds, only do a few at a time in small chunks. And don't swap the recovery model to bulk-logged. If you need to restore...
"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 13, 2014 at 6:35 am
It all has to do with permissions. I suspect your SQL Server instances are running under local accounts instead of under networked accounts. You'll have issues trying to communicate across...
"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 13, 2014 at 6:12 am
ASPState is difficult to deal with. Generally, isolating it as much as possible is the best bet. Better bet, don't use it for state management of your ASP pages. Storing...
"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 13, 2014 at 5:20 am
SQLRNNR (3/12/2014)
Lynn Pettis (3/12/2014)
SQLRNNR (3/12/2014)
Lynn Pettis (3/12/2014)
william.rees.howells (3/12/2014)
"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 12, 2014 at 8:14 pm
If you're on SQL Server 2012, then the answer is the Distributed Replay tool. With that you can simulate load on the system. You'll have to build the load yourself,...
"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 12, 2014 at 4:53 pm
Try modifying the system database called model to have the security settings you want as outlined above. Then, when you create a new database, what's in model is what gets...
"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 12, 2014 at 4:50 pm
Well, thinking about it some more, you can turn on auditing on the blob stores where the VM files are located. Set that to verbose and see what the heck...
"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 12, 2014 at 4:48 pm
No, statistics aren't modified by backups.
I've been using SQL Server on Azure in VMs a ton. I haven't seen this problem crop up before, so I'm seriously stumped on what...
"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 12, 2014 at 4:46 pm
No argument, but usually, it's relatively rare to change primary keys once a system has been built. It certainly doesn't make the early design and build stages or 1.1 releases...
"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 12, 2014 at 9:13 am
But a cost of 5 is so cheap that plans that shouldn't be parallel can get set up as parallel, running longer and using more resources than they should.
"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 12, 2014 at 7:06 am
GilaMonster (3/12/2014)
Am I slow today, or was this a little tricky to figure out? http://www.sqlservercentral.com/Forums/Topic1550137-1292-1.aspx
No, that one was weird.
"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 12, 2014 at 6:40 am
Do you have database backups? You'll need to go to those to restore your system.
"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 12, 2014 at 3:28 am
Viewing 15 posts - 8,686 through 8,700 (of 22,219 total)