Viewing 15 posts - 9,931 through 9,945 (of 22,224 total)
Throw money, uh, I mean, hardware at the problem. That's your only option.
"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
March 27, 2013 at 7:03 am
That value changes a lot over time. You can't look at it once and interpret anything from it. You must capture it continually. And, just because it changes doesn't mean...
"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
March 27, 2013 at 6:59 am
Just remember that the clustered index is both an index and the data. So if a query can use the index part of the cluster to satisfy the operations, 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
March 27, 2013 at 6:56 am
Actually, if you use extended events you can filter by batch_text in sql_batch_completed or by statement in rpc_completed and then use the like_i_sql_unicode_string to do a like statement looking...
"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
March 27, 2013 at 6:54 am
Ed Wagner (3/26/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
March 26, 2013 at 5:38 am
And then, if your databases are in FULL recovery, you need to set up regular log backups. I'd suggest at least once an hour.
"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
March 26, 2013 at 4:08 am
Sqlraider (3/25/2013)
Grant Fritchey (3/23/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
March 25, 2013 at 10:27 am
By default, all things being equal, it shouldn't be taking longer with 2008 SSMS. So, you have to figure out what's not equal. Again, are you capturing an execution plan?...
"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
March 25, 2013 at 8:45 am
Are you capturing the execution plan in the 2008 version of SSMS? Make sure you have the latest service packs installed on your server and on your client machine. Check...
"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
March 25, 2013 at 6:34 am
As Gail says, they'll be backed up. Then, when you go to restore, the part of the restore process known as recovery deals with uncommitted transactions, rolling them back as...
"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
March 25, 2013 at 3:33 am
In addition to backups, if you're developing the databases, I'd get the source for the structures and code into a source control management system. I'm pretty sure there ways 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
March 23, 2013 at 4:26 am
It will help some. Who does the maintenance on your SQL Server instance? If no one, you probably need to get that set up. That'll give you a lot more...
"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
March 23, 2013 at 4:25 am
I don't quite get how those numbers are laying out. Sorry.
You have max degree of parallelism set to 0, 1024, 0, 0? It's just a single value.
"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
March 22, 2013 at 11:30 am
Sorry, I can't tell anything from that. You can export an execution plan as a .SQLPLAN file and then load it up to the web site. Then I can see...
"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
March 22, 2013 at 11:22 am
That's roughly the opposite of what you ought to see. Can you get both actual execution plans and post them so we can see what the optimizer is 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
March 22, 2013 at 9:16 am
Viewing 15 posts - 9,931 through 9,945 (of 22,224 total)