Viewing 15 posts - 11,251 through 11,265 (of 22,224 total)
dopydb (2/22/2012)
good point on the monitoring..
i really dont think its a memory issue as it has 26gb of ram- which is relative i know- but i have seen just...
"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
February 22, 2012 at 6:44 am
Stuff like ESX Replication[/url] and DoubleTake make VMs pretty hot. There are whole lot of other management aspects to VM that make them great. My personal take is, unless you...
"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
February 22, 2012 at 6:42 am
Virtualization of the server adds a layer of processing and is therefore slower, no matter what.
That said, there are a bunch of reasons to use virtual machines in different environments...
"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
February 22, 2012 at 6:09 am
You need to gather metrics on the 2000 server and then pass those on. The code and structure are not going to change by migrating from 2000 to 2005. That...
"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
February 22, 2012 at 4:18 am
As far as the apathy goes, most people are apathetic about almost all their basic rights. I'm pretty sure a healthy majority of people would be willing to sacrifice freedom...
"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
February 21, 2012 at 8:52 am
Jeez Jeff. Next time mark it URGENT or NEED HELP NOW. Then I'd be sure to ignore it.
By the way, as far as posting goes, I didn't set it up...
"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
February 20, 2012 at 4:03 am
It partly depends on your table structure. What's the cluster key? If you're looking at a heap, or if the cluster key distributes the data across the whole database, then...
"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
February 20, 2012 at 3:49 am
Yes, sorry, SQL Data Compare, you're right.
Hmmm... I think you need to view server state to make that work.
"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
February 16, 2012 at 10:09 am
Stefan Krzywicki (2/16/2012)
Brandie Tarvin (2/16/2012)
"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
February 16, 2012 at 7:49 am
Jeff Moden (2/16/2012)
Grant Fritchey (2/16/2012)
Get a copy of Red Gate SQL Compare and just capture the data that exists in one database, but not the other. Very easy that...
"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
February 16, 2012 at 6:49 am
GilaMonster (2/16/2012)
Grant Fritchey (2/16/2012)
The real shocker is that you don't occasionally get the 30 minute execution anyway.
Variables, not parameters, so no parameter sniffing and the optimiser probably mis-guessing the row...
"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
February 16, 2012 at 6:26 am
Jody.WP (2/16/2012)
What is your database archiving strategy? I am asking this because I faced similar problems and our infrastructure guys is still taking their sweet time allocating...
"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
February 16, 2012 at 6:17 am
If the amount of log space needed for the processing is 100gb, then I'd give it that much space and leave it alone. If you only have 100gb... yeah, 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
February 16, 2012 at 6:11 am
One thing that might make a difference is if you use the variables multple times or call gETDATE() multiple times, the latter can result in different values. If that's 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
February 16, 2012 at 6:07 am
Just remember that backups don't help down time. If you want to improve the recovery time in the event of an outage, in addition to the backups you have, you...
"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
February 16, 2012 at 6:05 am
Viewing 15 posts - 11,251 through 11,265 (of 22,224 total)