Administrative tasks

Dear Friends
I want to do the following for my sql server kindly
suggest how i can do the same.
- Check the SQL cluster set-up and suggest
adpatations/improvements or additionnal hardware
requirements
- Check RAM caching
- Analyse partitionng options and make suggestion
- Identify performance issues and suggest
adapatations/improvements indexes, index views
- Create an adequate maintenance plan.
Thanks and best regards
Sharad1) Hire a qualified DBA
OR
2) Become a qualified DBA
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Sharad" <niitmalad@.yahoo.co.in> wrote in message
news:10df01c4cbd2$f0ce9e60$a501280a@.phx.gbl...
> Dear Friends
> I want to do the following for my sql server kindly
> suggest how i can do the same.
> - Check the SQL cluster set-up and suggest
> adpatations/improvements or additionnal hardware
> requirements
> - Check RAM caching
> - Analyse partitionng options and make suggestion
> - Identify performance issues and suggest
> adapatations/improvements indexes, index views
> - Create an adequate maintenance plan.
> Thanks and best regards
> Sharad|||Sharad,
That's not likely a list of tasks that someone can answer in
a newsgroup posting. You can find some maintenance and
monitoring guidelines in the Operations Guide at:
http://www.microsoft.com/TechNet/pr...in/sqlops0.mspx
You can find some performance monitoring and tuning articles
at:
http://www.sql-server-performance.com/
-Sue
On Tue, 16 Nov 2004 03:53:51 -0800, "Sharad"
<niitmalad@.yahoo.co.in> wrote:

>Dear Friends
>I want to do the following for my sql server kindly
>suggest how i can do the same.
>- Check the SQL cluster set-up and suggest
>adpatations/improvements or additionnal hardware
>requirements
>- Check RAM caching
>- Analyse partitionng options and make suggestion
>- Identify performance issues and suggest
>adapatations/improvements indexes, index views
>- Create an adequate maintenance plan.
>Thanks and best regards
>Sharad