Viewing 15 posts - 7,996 through 8,010 (of 22,219 total)
Wait stats tell you what the server is waiting on. But, you can't know if you have a performance problem by only looking at cumulative wait times, even though you're...
"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
June 12, 2014 at 6:42 am
IT researcher (6/12/2014)
SQL server restarts every night. Does these values reset on restart?
Yes, it's since a restart. So this is cumulative since that restart. But, normal can only be...
"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
June 12, 2014 at 6:12 am
GilaMonster (6/12/2014)
IT researcher (6/12/2014)
SQL server restarts every night. Does these values reset on restart?
wait times are cumulative since SQL started
For a change I'm going to disagree with Grant. Daily...
"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
June 12, 2014 at 6:08 am
Without seeing the query plan, the structures, the query... nope, not really.
My tests show a pretty consistent faster behavior for the natively compiled procedures.
"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
June 12, 2014 at 5:29 am
The very best wait times are zero.
But, that's not going to happen, so you need to know how your waits are changing over time to determine if there are issues....
"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
June 12, 2014 at 5:27 am
[/url]
And, I'm with Gail, turn off auto shrink.
"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
June 12, 2014 at 3:46 am
The Import/Export wizard can work, but if you hit issues where you need to manually intervene it can be a pain. I'd say the best bet would be to build...
"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
June 12, 2014 at 3:43 am
I'd go with the DENY approach and then make sure that only appropriate people have access to the system.
However, that's not even the scary thing. The scary thing is when...
"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
June 12, 2014 at 3:41 am
You can usually access lower versions of SQL Server from higher versions of SSMS, but the other way around leads to errors. If you need to manage both 2005 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
June 12, 2014 at 3:39 am
I would imagine that while you're looking at them those processes might be idle, but that they're not idle all the time. When they're not idle, they could be using...
"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
June 12, 2014 at 3:35 am
The issue is around even older versions of SQL Server. You can't take a SQL Server 2000 backup and restore it to 2012. You have to convert it to 2005...
"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
June 12, 2014 at 3:34 am
Personally, I think the blame lies mostly with the DBAs. Ten to Fifteen years ago, when all the modern development paradigms were starting to shake out, when object oriented programming...
"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
June 12, 2014 at 3:28 am
I have not noticed a general slowdown with SQL Server 2014, so some more details are needed in order to understand what's happening. Although, it's possible that it's the version...
"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
June 11, 2014 at 4:02 am
There's not a real way to say Plan A is better than Plan B. Instead, Plan A results in behavior 1,2,3 and Plan B results in behavior 4,5,6. It's 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
June 10, 2014 at 12:01 pm
GilaMonster (6/10/2014)
Jeff Moden (6/10/2014)
But that's what I'm talking about. That doesn't sound "fully durable" to me but I could be mistaken in what my definition of "fully durable" means.
Hang...
"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
June 10, 2014 at 11:55 am
Viewing 15 posts - 7,996 through 8,010 (of 22,219 total)