Viewing 15 posts - 9,451 through 9,465 (of 22,232 total)
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
Kurt W. Zimmerman (10/7/2013)
Grant Fritchey (10/7/2013)
Create a script that restores the database and make the procedures you need part of the script (after the restore of...
"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:53 am
This question was asked in more than one forum. Please put all further responses on this post since two of us have already responded over there.
"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:37 am
Viewing 15 posts - 9,451 through 9,465 (of 22,232 total)