Viewing 15 posts - 7,351 through 7,365 (of 22,226 total)
It's actually a new thread from a divergence on another thread.
I'd say you need to define "down." Can SQL Server sit there chugging away with CPU hovering near 100% for...
"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
October 17, 2014 at 10:41 am
Bing worked, but only returned a single hit.
"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
October 17, 2014 at 9:05 am
If you're experiencing pain from Profiler, trace is one option, but since you're in 2008, you can use extended events. These are even more lightweight than trace and filter much...
"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
October 17, 2014 at 9:01 am
Ratheesh.K.Nair (10/16/2014)
Thanks Everyone for the inputs.
Databases don't time out. Does the Profiler gui put a substantial load on a system that can cause memory issues, leading to blocking causing timeouts?...
"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
October 17, 2014 at 7:34 am
But if there is a SQL Server 2012 instance, you can download and install SQL Server Management Studio for no cost. Actually, I don't even think you need to have...
"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
October 17, 2014 at 6:08 am
I'd suggest a combination of capturing query performance metrics using extended events, and monitoring what is using tempdb by looking at sys.dm_db_session_space_usage dynamic management view. You need to know 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
October 17, 2014 at 6:06 am
And lanyrd is up to date now.
"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
October 17, 2014 at 5:53 am
Yep, what Gail says. It's also in my signature below my posts.
"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
October 17, 2014 at 5:52 am
Koen Verbeeck (10/17/2014)
Grant Fritchey (10/17/2014)
And might I add, it was odd seeing my name as a topic. Ha!Who knew you'd get this popular? 😀
All thanks to those photos with 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
October 17, 2014 at 4:01 am
Best of luck on the project. There are a lot of third party tools already filling this niche in various ways, just so you know.
"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
October 17, 2014 at 3:50 am
Hard to make suggestions based on simply suggesting the number of jobs that a system can support. I've seen systems support outrageously high numbers of jobs, but the jobs were...
"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
October 17, 2014 at 3:48 am
Also remember that changes in the optimizer from one version of SQL Server to the next can result in different query behavior. Most of the time you only see 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
October 17, 2014 at 3:44 am
It really depends on what you're trying to do. If you need all records from table and only those that match from the other, LEFT JOIN is the way 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
October 17, 2014 at 3:27 am
And might I add, it was odd seeing my name as a topic. Ha!
"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
October 17, 2014 at 3:24 am
I try to use lanyrd.com to track upcoming events. I think I'm a little behind on that at the moment. I do post upcoming events on my blog as well....
"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
October 17, 2014 at 3:20 am
Viewing 15 posts - 7,351 through 7,365 (of 22,226 total)