asked on

SQL Server Fine Tuning

I am looking for some best practices and approaches

1) SQL Performance. What are some good procs and/or processes to run to see where SQL is not performing so well.
Is there a way to systematically review the SQL server and see problem indexes, stats, etc on an entire database versus just the typical query analyzer.

2) What is a best practices approach for sql maintence. I realize keeping the log files low is important..but what else should be done and how often.

Thanks

ASKER CERTIFIED SOLUTION

Ryan McCauley

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

arnold

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Robb Hill

ASKER

in this case I would represent the vendor. And the DB can be different sizes, version, server spec..these are all variables based on customer.

Additionaly memory is fine. And we manage that effectively in most cases...
This is more about the internals to sql server itself.
Having processes in place that effectively keep sql server healthy.

Also being able to determine just how health the db is based on some baseline.

I think the blitz stored procs might do the trick for analysis.

Or atleast a starting point to determine what to look at deeper

arnold

Are you setting up the system and need to monitor the progression over time?
You could setup data collection using perfmon to pull and store data in a database and use that data to see the progression of the SQL performance.......

SOLUTION

Scott Pletcher

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Ryan McCauley

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Robb Hill

ASKER

Thanks again!!!