Viewing 15 posts - 7,426 through 7,440 (of 22,219 total)
If you want to do the second thing, you'll need to build that as a string and then execute the string.
DECLARE @ExecProc AS VARCHAR(75) --or something much bigger, depending
SET @ExecProc...
"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
September 26, 2014 at 3:51 am
You can see some long running queries in the system_health extended event session. It might show you where you had some issues. It might not, but it's something.
"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
September 26, 2014 at 3:44 am
There's nothing that Red Gate does that will capture this information. The one place I know you can get it without any changes to your system is the system_health extended...
"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
September 26, 2014 at 3:35 am
100% agreement. With few exceptions, every table should have a clustered index. Selecting that index is actually part of designing the database. The one consideration I would add on top...
"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
September 26, 2014 at 3:29 am
If you really don't want to learn extended events (and I can't think of a good reason why not) and you still want to see what queries have been doing...
"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
September 26, 2014 at 3:15 am
Phil Parkin (9/25/2014)
Grant Fritchey (9/25/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
September 25, 2014 at 9:14 am
This is exactly why you should be using source control to modify all your database objects, just as developers use it to modify code. Unless you set up auditing, and...
"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
September 25, 2014 at 8:00 am
SQLRNNR (9/25/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
September 25, 2014 at 7:40 am
That's the only place I'm aware of to make those kinds of changes.
"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
September 25, 2014 at 7:17 am
Wison (9/25/2014)
you can use profiler on third server to Monitor the sql statements which cause the CPU high.or
get the sql statements from the DMV.
Use trace or extended events 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
September 25, 2014 at 6:43 am
You can have a section in your resume called Certifications and list it there. As to writing the manual, that should be part of the description of that job.
"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
September 25, 2014 at 6:39 am
Try going to the Options screen, Environment, Keyboard. Then you can try doing a reset on the keyboard scheme you're on. That ought to do 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
September 25, 2014 at 6:33 am
It really depends on how the optimizer is resolving those queries. It's also dependent on how you're writing the queries. AND, it's dependent on the indexes you have on 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
September 24, 2014 at 12:00 pm
works extremely well, even with users connected.
"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
September 24, 2014 at 11:53 am
Jeff Moden (9/24/2014)
Chowdary's (9/24/2014)
I installed Red Gate Soft and using but its very costly tools ,as we are in small infrastructure my management will not 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
September 24, 2014 at 8:08 am
Viewing 15 posts - 7,426 through 7,440 (of 22,219 total)