Viewing 15 posts - 10,141 through 10,155 (of 22,232 total)
bitbucket-25253 (1/25/2013)
Steve Jones - SSC Editor (1/25/2013)
Are the posted posts about the posted questions and posted answers getting posted worse-ly than previous posters posted in the posted past?
NO, NO, NO,...
"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 25, 2013 at 11:28 am
Even on large systems, it comes down to the code, the indexes and the statistics. You've got to structure the indexes appropriately to support the queries you need to 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
January 25, 2013 at 10:39 am
sqlnaive (1/25/2013)
"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 25, 2013 at 8:59 am
surilds (1/25/2013)
Any Third party tool provides this information??
Are there? Sure, but what you want is pretty simple. Extended Events is a snap to set up and will do exactly what...
"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 25, 2013 at 8:49 am
Sorry, my email was offline so I wasn't getting messages. Sounds like Chris largely has it in hand.
"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 25, 2013 at 8:47 am
Since you're on SQL Server 2012, I would advise avoiding trace events. Instead focus on extended events. They're more light weight and much more programmable. There's no book available on...
"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 25, 2013 at 5:54 am
anthony.green (1/25/2013)
Hence why you should use a script...
"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 25, 2013 at 5:50 am
Table partitioning is primarily a mechanism of data management, not of performance tuning. Partitions allow you to add or remove data by working with large chunks, the partition, rather than...
"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 25, 2013 at 5:46 am
SQL Server doesn't store the previous executions of queries. You can look at the aggregation of queries currently in cache using sys.dm_exec_query_stats, but it doesn't have execution context (who ran...
"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 25, 2013 at 5:40 am
I agree. It sounds like parameter sniffing is leading to issues. I would suggest updating the statistics on the tables being referenced. In addition to the solutions for parameter sniffing,...
"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 25, 2013 at 5:36 am
There are probably lots of other issues in and around this, but the repeated pattern that looks like this:
where coalesce(p.ImageSequenceId,0)
is absolutely killing performance. Every single one of those 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
January 25, 2013 at 5:23 am
padhu.mukku (1/24/2013)
Try 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
January 25, 2013 at 5:17 am
Oh, that's right Kevin. I completely forget that you get four mirrors of the active server. That one is big too. Nice catch.
I'm just a little surprised that this 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 24, 2013 at 8:56 am
There are several reasons why Availability Groups might be preferred to a Cluster. First, and most importantly, you're not sharing any resources at all. In a cluster if the disk...
"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 24, 2013 at 8:25 am
Nah, I'd say you're digging a bit of a hole. Instead how about something like
Recurrence ... whatever columns are unique to the recurrence
RecurrenceSchedule ... just a listing of each of...
"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 24, 2013 at 8:14 am
Viewing 15 posts - 10,141 through 10,155 (of 22,232 total)