Viewing 15 posts - 11,551 through 11,565 (of 22,219 total)
Ninja's_RGR'us (12/6/2011)
Grant Fritchey (12/6/2011)
LutzM (12/6/2011)
Ninja's_RGR'us (12/6/2011)
...Would have been such a slam dunk of either of Jeff, Gail or I had been the single finalist from ssc! 😉
I guess 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
December 6, 2011 at 10:50 am
Krasavita (12/6/2011)
If you look under this screen there is only one option to use the same account for all sql Services,but how can I go and...
"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
December 6, 2011 at 10:35 am
LutzM (12/6/2011)
Ninja's_RGR'us (12/6/2011)
...Would have been such a slam dunk of either of Jeff, Gail or I had been the single finalist from ssc! 😉
I guess I know why neither...
"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
December 6, 2011 at 10:33 am
LutzM (12/6/2011)
Changing subject: Does anyone know one of the DBAinSpace finalists?There's no name I recognize as one of the Threadizens....
I'm friends with Tim Ford. He's an MVP. He runs SQL...
"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
December 6, 2011 at 10:31 am
Oh, sure. I'd suggest taking a look at SQL Monitor[/url] from Red Gate Software then. .
"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
December 6, 2011 at 10:26 am
Krasavita (12/6/2011)
ok, I am in the process of installing,so how can I Leave 2GB for the OS(where do I check for this?)Thank you
After you do the install, you change 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
December 6, 2011 at 9:07 am
Krasavita (12/6/2011)
This is I always can't get it right,how much set max memory?Thank you
It depends on the system, but, in general, you should retain 1-2gb for the OS, so set...
"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
December 6, 2011 at 7:05 am
It sure sounds like it's statistics related. When you rebuild the stats, are you using sp_updatestats or are you running UPDATE STATISTICS? If the former, try using the latter and...
"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
December 6, 2011 at 6:57 am
When you say performance tuning, what do you mean? Do you mean monitoring and alerting or something that will literally suggest or make changes to your system and/or queries?
"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
December 6, 2011 at 6:50 am
I really don't think this is a good solution for a production system, at all, but if you want very fast restores, you should take a look at something like...
"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
December 6, 2011 at 6:32 am
I'm with Steve. However, this checklist will give you a starting point.
"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
December 6, 2011 at 6:26 am
Performance on that query should be interesting. By interesting I mean, very, very slow.
Just so you know, LIKE statements with a leading wild card lead to scans with no opportunity...
"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
December 6, 2011 at 6:24 am
Ninja's_RGR'us (12/5/2011)
Grant Fritchey (12/5/2011)
Ninja's_RGR'us (12/5/2011)
Grant Fritchey (12/5/2011)
Ninja's_RGR'us (12/5/2011)
I'm pretty sure you meantI'm NOT trying to fight with you,
😀
Ah! the joys of not being f2f :hehe:.
Oh crap!
I edited that. Oops....
"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
December 5, 2011 at 5:34 pm
Ninja's_RGR'us (12/5/2011)
Grant Fritchey (12/5/2011)
Ninja's_RGR'us (12/5/2011)
I'm pretty sure you meantI'm NOT trying to fight with you,
😀
Ah! the joys of not being f2f :hehe:.
Oh crap!
I edited that. Oops. I'm sure 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
December 5, 2011 at 4:46 pm
Ninja's_RGR'us (12/5/2011)
I'm pretty sure you meantI'm NOT trying to fight with you,
😀
Ah! the joys of not being f2f :hehe:.
Oh crap!
I edited that. Oops. I'm sure that didn't help at...
"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
December 5, 2011 at 11:48 am
Viewing 15 posts - 11,551 through 11,565 (of 22,219 total)