Viewing 15 posts - 6,946 through 6,960 (of 22,219 total)
Yeah, tuning the queries so that they run correctly is always a good 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
January 12, 2015 at 4:38 am
Then the implication is that you have some process or other that's hitting 400 of the 500gb worth of pages on your database. Is there a nightly load or some...
"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
January 12, 2015 at 4:34 am
Are you initializing each backup file or are you stacking them together into a single file?
"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
January 12, 2015 at 4:17 am
You should take a look at the Resource Governor.
"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
January 11, 2015 at 10:41 am
Functions on columns like this are going to lead to scans on your indexes
and iif((@StartDate = '1900-01-01' or @EndDate = '1900-01-01'), '1900-01-01',PO.CalendarDate)
...
"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
January 11, 2015 at 6:15 am
The amount of time it takes is completely dependent on the size of the index in combination with the ability to get access to resources. At 1.5tb, it's going 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
January 11, 2015 at 6:06 am
100% agreement with all that Jeff said.
One question. If you're not doing differential backups, is it any big deal that they have an extra full backup going on?
"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
January 11, 2015 at 6:02 am
You may also see this if the extension is different. It's one of the many reasons I prefer using scripts for restore anyway. The GUI is limiting and difficult.
"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
January 11, 2015 at 6:00 am
sys.dm_db_index_usage_stats is also where I would think to look. Just remember that a reboot will zero out those metrics, so you may see databases that haven't been accessed, but 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
January 11, 2015 at 5:58 am
Glad to hear it's helpful. As this technology grows and changes, it all starts to resemble magic.
I think the most interesting takeaway I got from the discussion was that, essentially,...
"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
January 11, 2015 at 5:45 am
No, they can adjust the disks, but most of the time the disks are adjusted for the most money saving setting, saving disk space, not speed. However, before you 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
January 10, 2015 at 3:31 pm
You can't think about LUNs the same way you think about drives. They're not the same. Instead, the focus has to be in IOPS. What are you getting? If it's...
"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
January 10, 2015 at 4:30 am
I'd try SELECT @@SPID as well as selecting from sys.dm_exec_requests, sys.dm_exec_connections (I think) to see what's there.
Still sounds a little odd.
"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
January 9, 2015 at 3:49 pm
I had a great conversation with Alan Hirt about this last night at the New England SQL Server User Group.
The way he put it is that, in the old days,...
"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
January 9, 2015 at 3:46 pm
Jeff Moden (1/9/2015)
Brandie Tarvin (1/9/2015)
I've been through 5 managers...BWAAAA-HAAAAA-HAAAA!!!! You must be tough on managers! :-D:-P
I'm finishing up my fourth year at Redgate and I'm on my fourth manager....
"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
January 9, 2015 at 12:49 pm
Viewing 15 posts - 6,946 through 6,960 (of 22,219 total)