Viewing 15 posts - 12,931 through 12,945 (of 22,227 total)
I'd run a server-side trace to see what kind of queries are being run to understand why I might be getting intermittent time outs. That or look to see 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 9:01 am
Brandie Tarvin (3/24/2011)
Grant Fritchey (3/24/2011)
I grew up in a sane place, Oklahoma.
USE SSC;
SET SnarkFactor = ON;
GO
Wow. I remember when Oklahoma was actually worthy of being a football rival for Nebraska....
"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 8:57 am
But if some other app pages into memory, it's going to impact SQL Server, and hence the problem you're hitting. I'm not surprised. You're basically in a tough spot. You...
"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 8:55 am
Gianluca Sartori (3/24/2011)
Grant Fritchey (3/24/2011)
Gianluca Sartori (3/24/2011)
Grant Fritchey (3/24/2011)
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 8:34 am
Yes, but index fragmentation and statistics being up to date are two very different things. You can have very low fragmentation and statistics that are quite old. You're dealing with...
"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 8:32 am
Ah, so, there are other apps running on the machine? That's more than likely the issure, right there. SQL Server does not like to play well with others. In almost...
"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 8:29 am
Gianluca Sartori (3/24/2011)
Grant Fritchey (3/24/2011)
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:53 am
yes, you can always go and get it from codeplex.com
"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:38 am
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
Viewing 15 posts - 12,931 through 12,945 (of 22,227 total)