Viewing 15 posts - 14,611 through 14,625 (of 22,219 total)
"Dirty data" doesn't have a precise definition. One definition of it is data inside the system in an uncommitted state. It's in the middle of a transaction and therefore, dirty....
"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
July 20, 2010 at 9:30 am
We use both SCOM and Idera's Diagnostic Manager. They monitor different stuff in different ways.
"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
July 20, 2010 at 9:26 am
I'd say no. Your issue is that the procs are not in the cache, but it's not necessarily a memory problem. It's much more likely to be a coding issue....
"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
July 20, 2010 at 6:34 am
But even the management data warehouse has to be enabled and the data kept in order to go back in time to retrieve it.
Basically, the answer is, unless you've...
"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
July 20, 2010 at 5:49 am
Jack Corbett (7/19/2010)
The Dixie Flatline (7/19/2010)
I'm getting to come again this year. How early do volunteers have to arrive?
If you mean volunteer for the Summit, there is usually...
"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
July 20, 2010 at 5:14 am
CirquedeSQLeil (7/19/2010)
Is Denny Cherry running too?
He submitted, yeah. Saw that on Twitter.
"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
July 19, 2010 at 12:32 pm
Steve Jones - Editor (7/19/2010)
Grant Fritchey (7/19/2010)
Jack Corbett (7/19/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
July 19, 2010 at 11:55 am
Jack Corbett (7/19/2010)
Grant Fritchey (7/19/2010)
Jack Corbett (7/19/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
July 19, 2010 at 8:31 am
Jack Corbett (7/19/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
July 19, 2010 at 7:55 am
I've had great success using Quest's Benchmark Factory[/url]. It lets you define a load, scale it carefully... it's a great tool.
"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
July 19, 2010 at 7:42 am
Steve Jones - Editor (7/16/2010)
I think Simple Talk uses LuLu.
They do but LuLu has some problems too. There was a guy copying books and posting them under his name, 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
July 19, 2010 at 5:32 am
Lynn Pettis (7/16/2010)
I hope I wasn't ambiguous in my last response to this...
"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
July 16, 2010 at 11:23 am
TheSQLGuru (7/16/2010)
I LOVE ORMs!! They create SOOO many business opportunities for me due to the bad stuff they (and the developers who use them) do with databases! 😎
I...
"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
July 16, 2010 at 11:19 am
Kit G (7/16/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
July 16, 2010 at 11:16 am
Actually, it is working. It was pointed out to me that sp_who2 returns two SPID columns. That's the only isue.
"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
July 16, 2010 at 10:51 am
Viewing 15 posts - 14,611 through 14,625 (of 22,219 total)