Viewing 15 posts - 12,676 through 12,690 (of 22,219 total)
Did you update the statistcs after the upgrade?
There are a few instances where queries, especially complex or convaluted queries, had different execution plans after the upgrade due to regressions. Have...
"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
April 22, 2011 at 5:31 am
If your log is growing like crazy, are you in FULL recovery and if so, are you running log backups. Having databases in FULL recovery and not running log backups...
"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
April 22, 2011 at 5:28 am
I'm not sure that I'd worry too much about that. I'd focus on Lock Timeouts/sec and Lock Wait Time. Those are better indications of issues with locking than simply getting...
"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
April 22, 2011 at 5:23 am
I'm not familiar with Compellent, but I went to their web site. It looks to me like it's a SAN management and backup software. Is that right?
If so, those 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
April 22, 2011 at 5:20 am
The other thing you can do with the trace data is feed it into the RML utilities. That will give you good reports on the longest running query, etc. From...
"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
April 22, 2011 at 4:59 am
If I were doing it, I'd probably do that first.
"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
April 21, 2011 at 7:35 am
Matt-1034261 (4/21/2011)
Grant Fritchey (4/21/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
April 21, 2011 at 7:19 am
Yes, it will. Just don't make any plans around shrinking databases on a regular basis. It really causes problems.
"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
April 21, 2011 at 5:46 am
Rajesh Desai-289863 (4/21/2011)
a) restoring the logs
b) changing the backup to simple and then back to full , taking a full backup
After a transaction lob backup ( which does...
"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
April 21, 2011 at 5:44 am
I would check your backup job. Unless your server has gone completely around the bend in a way I've never heard of, this command
BACKUP LOG MyDatabase TO DISK = 'somepath'
Will...
"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
April 21, 2011 at 5:27 am
Yeah, that does make a slight difference. OK, let's look at it a different way, have you looked at the wait stats on the server? Are you waiting behind statistics...
"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
April 21, 2011 at 5:22 am
I'm more than a bit list too. What error are you getting when you add the column to the CTE. Yes, you should be able to add a column 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
April 21, 2011 at 5:19 am
Check the server roles. Sounds like they might be sys admin on the box.
"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
April 21, 2011 at 5:16 am
You're going to be hard pressed to find a good, comprehensive training program that is also completely free. How about picking up a book? I was one of the authors...
"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
April 21, 2011 at 5:15 am
If you're assigning variables from a SELECT statement you just do this:
DECLARE @FirstVariable int, @SecondVariable int, @ThirdVariable int
SELECT @FirstVariable = FirstColumn,
@SecondVariable = SecondColumn,
@ThirdVariable = ThirdColumn
FROM MyTable
But, that query can only...
"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
April 21, 2011 at 5:09 am
Viewing 15 posts - 12,676 through 12,690 (of 22,219 total)