Viewing 15 posts - 11,776 through 11,790 (of 22,224 total)
saidapurs (9/30/2011)
Hi Grant,I got your point, but can you tell me where or what type of security shall i change in SQL SERVER
Go to the Configuration...
"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
September 30, 2011 at 6:21 am
You'll never see exactly the same behavior. So, you tune in combination with looking at the scans and reads. Looking at both you'll start to see whether or not 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
September 30, 2011 at 6:05 am
saidapurs (9/30/2011)
Hi,UNC path is correct, locally & as well as Network also accessible......
The thing is, when you run a backup, YOU issue the command, but...
"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
September 30, 2011 at 5:46 am
Red Gate isn't built for maintaining hundreds of instances of SQL Server (yet), based on the scale you're looking at, I'd suggest either Microsoft SCOM or SQL Sentry. Either should...
"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
September 30, 2011 at 5:44 am
WayneS (9/29/2011)
Gail / Grant - are the sessions that you'll are doing during the 3-day portion of the summit going to be covered during your precon?
Tiny amount of cross-over, very...
"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
September 30, 2011 at 4:24 am
GilaMonster (9/29/2011)
Evil Kraig F (9/29/2011)
GilaMonster (9/29/2011)
Wooooooooot!!!!!!!!!!!!!!!!!!2 years, many, many weekends, late nights and a mad rush to the end (and I'm not even counting the ones Jonathan did), it's here
Awesome...
"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
September 29, 2011 at 1:00 pm
Evil Kraig F (9/29/2011)
GilaMonster (9/29/2011)
Wooooooooot!!!!!!!!!!!!!!!!!!2 years, many, many weekends, late nights and a mad rush to the end (and I'm not even counting the ones Jonathan did), it's here
Awesome Gail,...
"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
September 29, 2011 at 12:59 pm
But wait, if your CPU is maxing out, what makes you think it's memory pressure? I can see I/O issues from memory pressure as more and more stuff is cached...
"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
September 29, 2011 at 5:58 am
Ooops. Misread that question. Gail is right. It's not stored twice. I just meant it's stored anyway... sorry about that.
"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
September 29, 2011 at 5:56 am
GilaMonster (9/29/2011)
Grant Fritchey (9/29/2011)
GilaMonster (9/29/2011)
Wooooooooot!!!!!!!!!!!!!!!!!!2 years, many, many weekends, late nights and a mad rush to the end (and I'm not even counting the ones Jonathan did), it's here
Well done...
"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
September 29, 2011 at 5:54 am
sys.dm_exec_query_stats and sys.dm_exec_procedure_stats are aggregates showing all the times that the query has been called. No way to link it to an individual call, as Gail says.
"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
September 29, 2011 at 4:53 am
Yes. You're right. The cluster key is stored as part of non-clustered indexes anyway.
"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
September 29, 2011 at 4:51 am
islandwino (9/28/2011)
Grant Fritchey (9/28/2011)
I ask because I'm the product...
"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
September 29, 2011 at 4:48 am
setvij (9/28/2011)
"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
September 29, 2011 at 4:45 am
GilaMonster (9/29/2011)
Wooooooooot!!!!!!!!!!!!!!!!!!2 years, many, many weekends, late nights and a mad rush to the end (and I'm not even counting the ones Jonathan did), it's here
Well done Gail. I 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
September 29, 2011 at 4:42 am
Viewing 15 posts - 11,776 through 11,790 (of 22,224 total)