Viewing 15 posts - 14,626 through 14,640 (of 22,232 total)
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
Half way there.
Changed:
$job = Invoke-Command -ComputerName (Get-Content "c:\scripts\serverlist.txt") -ScriptBlock {Invoke-Sqlcmd -ServerInstance $instances.$env:computername -Query "exec sp_who2"} -JobName tsql -ConfigurationName MyShell
To:
$job = Invoke-Command -ComputerName (Get-Content "c:\scripts\serverlist.txt") -ScriptBlock {param($instances) Invoke-Sqlcmd -ServerInstance $instances.$env:computername...
"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 9:58 am
I freely admit to feeling extreme depression at times because I'm just not as smart as many of the people I know and I've met. It can be daunting 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 16, 2010 at 5:29 am
Viewing 15 posts - 14,626 through 14,640 (of 22,232 total)