Viewing 15 posts - 13,771 through 13,785 (of 22,219 total)
1. Normalization is a part of design, as Paul says. The amount of weight that goes behind it? A lot. You really should normalize the database design properly or 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
December 28, 2010 at 7:52 am
I've been working for a large company and I set up, what we used to call in the Navy, a "Tiger Team." It was meant not as a leadership team...
"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
December 28, 2010 at 7:17 am
homebrew01 (12/23/2010)
Would the default trace files be of use to at least get some information about what heppened between 12:00 and 4:00 ?
Nope. The default trace does not capture DML...
"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
December 23, 2010 at 10:49 am
You've got a "very important" production database and no log backups and an untested recovery process? It's either not actually "very important" or you guys have a long and painful...
"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
December 23, 2010 at 7:07 am
I might be missing something, but couldn't you just do a GROUP BY on the date with a count? Seems like that would be a lot easier than loading temporary...
"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
December 22, 2010 at 1:20 pm
dajonx (12/22/2010)
"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
December 22, 2010 at 1:15 pm
dajonx (12/22/2010)
Unfortunately, we do not have a SAN. However, we are...
"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
December 22, 2010 at 12:04 pm
Another thought... just based on the level of pain, have you checked that your disks are aligned properly? It's not usually an issue, but if your local machine is running...
"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
December 22, 2010 at 12:03 pm
That's not a problem I've had to solve, but the winner of this year's Red Gate Exceptional DBA Award, Tracy Hamlin, deals with databases even larger than the one 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
December 22, 2010 at 10:43 am
Greg Edwards-268690 (12/22/2010)
Happy Holidays to all of the SSC threadizens and their families!Greg E
Right back at you and to everyone.
Yule just past, but Kris Kringle still has yet to visit...
"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
December 22, 2010 at 7:35 am
Piling on a bit, I agree. You just need to do fundamental data collection of the performance metrics. Use perfmon or, if you have a little money, you might pick...
"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
December 22, 2010 at 7:33 am
Once you know the CPU is high, I'd start drilling down on what's causing it to be that high. What processes are using it up? I'd go to the DMO...
"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
December 22, 2010 at 7:14 am
This is one of those places where the Microsoft documentation, best practices and advice is the best place to go for information. They really do lay out the choices correctly....
"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
December 22, 2010 at 7:11 am
Before you put different applications within a single database, I'd check to see just how much cross-dependencies there are between the apps. Do they share tables & procedures? If so,...
"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
December 22, 2010 at 7:06 am
It's pretty likely you're using one of the non-deterministic calls within the function. Check here to validate 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
December 22, 2010 at 7:01 am
Viewing 15 posts - 13,771 through 13,785 (of 22,219 total)