Viewing 15 posts - 12,931 through 12,945 (of 22,219 total)
Have you looked ath this documentation from Microsoft? I'd start there.
"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 24, 2011 at 7:34 am
Are there other softwares or utilities running on the machine?
"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 24, 2011 at 7:30 am
Jeff Moden (3/24/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 24, 2011 at 7:26 am
Roy Ernest (3/24/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 24, 2011 at 7:25 am
Jeff Moden (3/24/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 24, 2011 at 7:23 am
Stuff could break during the process, so you should make a backup before you do this, validate that the backup is good (by restoring it somewhere) and then make 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 24, 2011 at 7:19 am
I too have found, on occasion, that the rollback just won't finish. A reboot can (not won't) clear it much faster. You're taking a chance, but I'd try bouncing 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 24, 2011 at 7:18 am
You do have some disparity between estimated and actual rows, so you might have some issues with the age of your statistics. That clustered index seek on 300000 rows against...
"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 24, 2011 at 7:15 am
First, a view is not going to improve performance. A view is just a query. That's all.
To improve performance you need to understand how your database is being queried. If...
"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 24, 2011 at 7:04 am
Do you have a limit on the SQL Server memory setting? I'd look there first.
Second, what kind of queries are being run?
"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 24, 2011 at 6:59 am
I'd be curious how you're incorporating the 3rd party tool into your native backups, assuming that's what's going on. Also, why.
"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 24, 2011 at 4:59 am
When tuning queries the execution plan is a must. I know you said you have indexes, but we can't tell whether or not they're being used without the execution plan....
"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 24, 2011 at 4:54 am
ravisamigo (3/24/2011)
But I have tried to keep the database in suspect mode and set the alert severity to 23 but I couldn't get any alert.
In event eveviewer, I can see...
"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 24, 2011 at 4:51 am
It runs one way in the datawarehouse and one way when you call it using EXEC. Are these two different applications making the call? If so, I'd check the connection...
"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 24, 2011 at 4:47 am
Elliott Berkihiser (3/23/2011)
Gail, Grant
Thanks.
I understand how OPENQUERY directs the processing to the remote machine, and I'll look at that.
I was curious about the situation with Views. 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 23, 2011 at 4:11 pm
Viewing 15 posts - 12,931 through 12,945 (of 22,219 total)