Viewing 15 posts - 14,071 through 14,085 (of 22,219 total)
I don't know what the Plesky software is, so I can't help there.
If you can't run performance monitor on the server, but you are still interested in getting some 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 19, 2010 at 6:37 am
If you just take away their trace permissions on the server, they'll never know. Do they currently use trace? If not, they'll never miss those privs. If so, there's little...
"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 19, 2010 at 6:30 am
MpriorJ (10/19/2010)
My idea was to use the application, by entering...
"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 19, 2010 at 6:12 am
GilaMonster (10/19/2010)
Help me do the impossible: http://www.sqlservercentral.com/Forums/Topic1006743-357-1.aspx
Tossed in a penny. Let's hope it helps.
"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 19, 2010 at 6:02 am
The name "Maintenance Plan" pretty much defines what you're going to be building. A set of routines for maintaining your database and server. This is not the same thing as...
"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 19, 2010 at 6:01 am
GilaMonster (10/18/2010)
Craig Farrell (10/18/2010)
To go back to our earlier discussion on bad drivers in random places, apparently hit'n'runs are universal.
I nearly got side-swiped into a concrete barrier 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
October 18, 2010 at 1:45 pm
Lynn Pettis (10/17/2010)
Sorry, but I couldn't resist responding. We'll see how he takes my critizism (sp ?).
Oh hell, I posted. If he goes off on it or whatever, I'm...
"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 18, 2010 at 6:33 am
Developers may not want to use stored procedures, I get it, but you should at least use parameterized queries. This avoids T-SQL injection and will lead to plan reuse. 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
October 18, 2010 at 6:26 am
Anamika (10/17/2010)
Before going for a live data base what are the things we need to consider and steps should be taken as a vibrant intuitive DBA?
On memory utilization, space, Performance...
"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 18, 2010 at 6:21 am
Jeff Moden (10/17/2010)
Grant Fritchey (10/12/2010)
They should be used where appropriate...
I apologize for puting you on the spot but what do you consider an appropriate use for them is especially since...
"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 18, 2010 at 6:19 am
SQL Server and Windows offers a whole bunch of monitoring and management stuff for free. Perfmon and server-side traces can be used to keep an eye on your systems. If...
"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 15, 2010 at 12:24 pm
Except for certain operations the flush the cache, it's pretty much being constantly flushed, depending on the pressure on memory. But, to my knowledge, there's no way to know 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 15, 2010 at 12:09 pm
gianmh (10/15/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
October 15, 2010 at 12:03 pm
Oooh, I get to be the first one to say it...
"THERE CAN BE ONLY ONE!"
Welcome to the party.
"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 15, 2010 at 11:52 am
GilaMonster (10/15/2010)
<headdesk><headdesk><headdesk><headdesk>
(No, I'm not going into details, it's a little too sensitive a topic for that. 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
October 15, 2010 at 11:39 am
Viewing 15 posts - 14,071 through 14,085 (of 22,219 total)