Viewing 15 posts - 9,436 through 9,450 (of 22,219 total)
Set up a powershell command to connect to each of the servers and run a query. You can even use threading and remoting within powershell to have the queries run...
"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 21, 2013 at 4:29 pm
Sorry to say, I don't know anyone working for any of those three. My experiences with all outsourcing agencies is that the responses you get can be very uneven. 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
October 21, 2013 at 4:28 pm
In short, you're in a great situation. Leave it alone.
"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 21, 2013 at 4:27 pm
You can also use Policy Based Management to look at how many days it has been since a backup was run on a database. That's a great way to double...
"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 21, 2013 at 11:13 am
If you hit the issue again, I'd look for blocked processes. It's likely that you had one that was preventing your from completing what you were doing. You could 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 13, 2013 at 7:22 am
Another vote for Embarcadero ER Studio. It's a very solid tool.
You might also want to look at SQL Dependency Tracker from Red Gate. It's not a modeling tool, but 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
October 13, 2013 at 7:21 am
And remember, in addition to what everyone else has already correctly said about it, page life expectancy can change due to things that are not issues. It's pretty normal, 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 13, 2013 at 6:10 am
JBrosch (10/11/2013)
"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 12, 2013 at 7:43 am
A whole bunch of Threadizens here at SQL Saturday Charleston. I'm sitting next to Wayne as I type this.
Every Threadizen who makes it to the Summit must track me down...
"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 12, 2013 at 7:40 am
lsager 34516 (10/11/2013)
"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 12, 2013 at 7:36 am
Yep, Jonathan's blog and the Microsoft documentation are the way to go. Between the two you'll learn most of what you need.
"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 10, 2013 at 5:53 am
yeah, that'll help. The buffers don't get too specific, or rather, they get way too specific. If you expand them out, there's all sorts of information. It's just that most...
"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 8, 2013 at 3:58 am
Storage is just disks (or LUNs, or whatever). Nothing special about it at all. That's a big part of what makes it attractive. You don't have to have an specifics...
"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 7, 2013 at 12:39 pm
SQLRNNR (10/7/2013)
Steve Jones - SSC Editor (10/7/2013)
GilaMonster (10/1/2013)
SQLRNNR (10/1/2013)
Stand up in the middle as if to make an announcement and commence the "fun"?Nope. But have something in mind.
Panel cage match?...
"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 7, 2013 at 9:02 am
Jack Corbett (10/7/2013)
GilaMonster (10/7/2013)
Jack Corbett (10/7/2013)
"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 7, 2013 at 7:56 am
Viewing 15 posts - 9,436 through 9,450 (of 22,219 total)