Viewing 15 posts - 7,276 through 7,290 (of 22,226 total)
I'd take a look at extended events. You can just capture the events that exceed a certain value for run time and then have them forwarded to just about anything...
"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
November 10, 2014 at 8:16 am
Glad to hear it was narrowed down. It sure didn't sound like a physical problem. Good luck on the fix.
"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
November 6, 2014 at 6:11 am
Glad to hear it's proving useful. Let me know if you have questions.
"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
November 4, 2014 at 6:05 am
One of the first, and most important resources, you've already found. SQL Server Central is one of the best places to get more learning. Not only from the forums like...
"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
November 2, 2014 at 12:55 pm
With no information, I'm with Lynn. It's impossible to say what you need to do to improve performance.
But, whatever other forum you were on is partly correct. A view, 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
November 2, 2014 at 12:50 pm
In terms of a "backup" as defined by SQL Server backups, no.
But, as has already been pointed out, there are a number of mechanisms for scripting out the procedures. Might...
"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
November 2, 2014 at 12:43 pm
If it's waiting on the log, you need to look to contention within your I/O system. Can you separate your log and data onto different disks and disk controllers? Can...
"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
October 30, 2014 at 1:34 pm
Interesting. Glad you fixed it. Sorry I didn't have anything better to offer.
"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
October 30, 2014 at 1:31 pm
One generic index should be best. If you had created multiple indexes, all with the same key values, you might not see them used even in the queries that suggested...
"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
October 30, 2014 at 10:39 am
Just did a series of searches on both Bing and Google. There is no recorded instance that I can find of this part of the message:
"10.00.5500. That version is incompatible...
"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
October 30, 2014 at 10:37 am
That should work. I've never heard about or run into issues restoring an R2 database from a 2008 backup. Just did some searching online. Everything I'm finding suggests it's pretty...
"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
October 30, 2014 at 10:32 am
You do realize that indexes are absolutely wonderful things and extremely helpful in lots of situations? Lots of heap tables on a database sounds like a very questionable design. I'd...
"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
October 30, 2014 at 6:56 am
Matt Miller (#4) (10/29/2014)
Grant Fritchey (10/28/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
October 29, 2014 at 3:57 pm
cdesmarais 49673 (10/29/2014)
Grant Fritchey (10/28/2014)
cdesmarais 49673 (10/27/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
October 29, 2014 at 12:11 pm
The read out to get the extra data is going to happen one way or another. Even if you have a lookup back to the cluster, you'll have to read...
"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
October 29, 2014 at 10:23 am
Viewing 15 posts - 7,276 through 7,290 (of 22,226 total)