Viewing 15 posts - 12,781 through 12,795 (of 22,219 total)
What event are you capturing in the trace? When I run a trace on a database with forced parameterization set, I still see values passed in. If you're seeing that,...
"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 12, 2011 at 12:36 pm
You're asking for more control than is possible through SQL Server. DBCC is how you determine where data other than tables are stored. Tables storage is defined when you create...
"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 12, 2011 at 12:24 pm
Craig Farrell (4/12/2011)
Grant Fritchey (4/12/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 12, 2011 at 11:12 am
You've got a couple of options. My favorite is to use Dynamic Management Objects such as sys.dm_exec_requests or sys.dm_exec_sessions to see what's happening on the server. You can combine these...
"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 12, 2011 at 6:46 am
A key lookup or a RID lookup, operation is caused when the nonclustered index that the optimizer uses doesn't have all the columns to satisify the query. The common method...
"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 12, 2011 at 6:38 am
It really sounds like you've got a non-standard design, so I doubt any standard set of checklists on performance tuning is going to help. All the stuff Wayne supplied is...
"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 12, 2011 at 6:35 am
Piling on, Michele's scripts are excellent. I'd absolutely support putting those in place on any production system I supported.
"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 12, 2011 at 6:30 am
Craig Purnell (4/9/2011)
I have noticed that there are not any presentations on SQL Agent at the various SQL Saturday events and thought to fill a gap:
SQL Agent for the Beginner...
"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 11, 2011 at 4:20 pm
Scalability Doug (4/5/2011)
Ever wonder what's in your SQL Plan cache? Wonder...
"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 11, 2011 at 4:17 pm
Yep, absolutely, Itzik's books are the way to go.
"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 11, 2011 at 10:01 am
CANCER (4/8/2011)
This is what i am getting when i try to collect execution plan.
The query has exceeded the maximum number of result sets that can be displayed in the Execution...
"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 11, 2011 at 4:56 am
No short answers here. Are you sure it's memory that's the issue. Have you looked at wait states on the server? What are things waiting on? Have you gathered metrics...
"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 8, 2011 at 6:10 am
Just so you know, certification is unlikely to help you get hired or get started in a DBA job. In general, you're better off working your way in to a...
"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 8, 2011 at 6:09 am
CANCER (4/7/2011)
thanks for your reply
yes the db is in full recovery and log backups job is running succesfully for every hour.
we have clustered and non-clustered indexes on tables and 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
April 7, 2011 at 6:24 pm
Well, the optimizer isn't dumb, so it makes me wonder if something in your code is causing the problem. That's usually the issue.
"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 7, 2011 at 11:05 am
Viewing 15 posts - 12,781 through 12,795 (of 22,219 total)