Viewing 15 posts - 9,106 through 9,120 (of 22,219 total)
Sounds like a limit imposed by the operating system 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
January 8, 2014 at 2:04 am
Hmmm...
I would suspect the statistics are going out of date and leading to a bad plan which is locking everything up, but that's a guess. There's not quite enough information...
"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
January 8, 2014 at 2:03 am
Are you on the latest service pack and cumulative update? I still don't have time to really dig into this, but thinking about the missing statistics, I'm wondering if you're...
"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
January 8, 2014 at 1:49 am
I'm overseas currently. I'm going to have to get back to you on the details here.
"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
January 7, 2014 at 11:00 am
What David said is accurate. The entire cost for the plan is stored in the first operator, SELECT/UPDATE/DELETE/INSERT.
"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
January 7, 2014 at 10:58 am
chandan_jha18 (1/7/2014)
Grant Fritchey (1/7/2014)
chandan_jha18 (1/7/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
January 7, 2014 at 6:59 am
Without resorting to a third party software, you can't. The only way to access a backup is to restore it.
"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
January 7, 2014 at 6:03 am
So, you're not getting table scans, but the performance is still really bad? It may just be your process then.
Also, even though it's Express, you can use extended events or...
"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
January 7, 2014 at 6:02 am
chandan_jha18 (1/7/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
January 7, 2014 at 5:57 am
Thinking about it some more, it's also possible you need space in tempdb.
"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
January 7, 2014 at 2:22 am
I'd recommend expanding existing files or adding a file to the primary file group so that it has enough room to get the work done.
"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
January 7, 2014 at 2:03 am
Not sure based on what you've posted, but it's possible that you're filling the log file (and the drive). Is your database in Full Recovery mode? If so, are 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
January 6, 2014 at 11:05 pm
Yeah, pretty much SQL Agent. You can set up multi-server management with it too. I wrote an article on this topic a little while back that might be a little...
"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
January 6, 2014 at 11:01 pm
It kind of depends on how you define database dictionary, but check out Red Gate SQL Doc[/url].
Disclaimer: I work for Red Gate.
"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
January 6, 2014 at 10:59 pm
Since this is posted in the 2008 forum, you can use extended events to capture the query metrics at an extremely low cost to the server. That's what I would...
"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
January 6, 2014 at 10:56 pm
Viewing 15 posts - 9,106 through 9,120 (of 22,219 total)