TO DO List for HA DB Server

23 Jan 2006 1:06 PM

Kay

All,

Is there some document available for the TO DO List for HA DB Server on
daily, weekly, monthly or periodically.

It will help me to document these and work smarter.

TIA
Kay

23 Jan 2006 1:32 PM

Michael Hotek

What do you define as an HA DB server?

--
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.

Show quoteHide quote

"Kay" <Call***@hotmail.com> wrote in message
news:eYAPk3BIGHA.3144@TK2MSFTNGP11.phx.gbl...
> All,
>
> Is there some document available for the TO DO List for HA DB Server on
> daily, weekly, monthly or periodically.
>
> It will help me to document these and work smarter.
>
> TIA
> Kay
>

23 Jan 2006 1:58 PM

Kay

In production environment, we have a SQL Server which is suppose to be 24 x
7 up and running. I want some information what is required to look after in
order to make it available and it's health check.

Show quoteHide quote

"Michael Hotek" <m***@solidqualitylearning.com> wrote in message
news:O2%23ZGHCIGHA.604@TK2MSFTNGP14.phx.gbl...
> What do you define as an HA DB server?
>
> --
> Mike
> http://www.solidqualitylearning.com
> Disclaimer: This communication is an original work and represents my sole
> views on the subject. It does not represent the views of any other person
> or entity either by inference or direct reference.
>
> "Kay" <Call***@hotmail.com> wrote in message
> news:eYAPk3BIGHA.3144@TK2MSFTNGP11.phx.gbl...
>> All,
>>
>> Is there some document available for the TO DO List for HA DB Server on
>> daily, weekly, monthly or periodically.
>>
>> It will help me to document these and work smarter.
>>
>> TIA
>> Kay
>>
>
>

24 Jan 2006 7:44 AM

Uri Dimant

Kay

Start with

http://www.sql-server-performance.com/sql_server_performance_audit.asp

Show quoteHide quote

"Kay" <Call***@hotmail.com> wrote in message
news:uQY2QUCIGHA.1032@TK2MSFTNGP11.phx.gbl...
> In production environment, we have a SQL Server which is suppose to be 24
> x 7 up and running. I want some information what is required to look after
> in order to make it available and it's health check.
>
> "Michael Hotek" <m***@solidqualitylearning.com> wrote in message
> news:O2%23ZGHCIGHA.604@TK2MSFTNGP14.phx.gbl...
>> What do you define as an HA DB server?
>>
>> --
>> Mike
>> http://www.solidqualitylearning.com
>> Disclaimer: This communication is an original work and represents my sole
>> views on the subject. It does not represent the views of any other
>> person or entity either by inference or direct reference.
>>
>> "Kay" <Call***@hotmail.com> wrote in message
>> news:eYAPk3BIGHA.3144@TK2MSFTNGP11.phx.gbl...
>>> All,
>>>
>>> Is there some document available for the TO DO List for HA DB Server on
>>> daily, weekly, monthly or periodically.
>>>
>>> It will help me to document these and work smarter.
>>>
>>> TIA
>>> Kay
>>>
>>
>>
>
>

25 Jan 2006 6:43 PM

Michael Hotek

There are dozens of things to look at. You need to do the basic admin stuff
like reviewing error logs and event logs. You need to monitor security to
detect unauthorized access or operations. You need to ensure that the
databases are backed up, backups tested, and you have a recovery plan in
place. You need to monitoring performance and fix any issues related to
performance, blocking, and deadlocking. There's no simple way to spell all
of this out. There have been 800 page books written on this topic that
barely scratched the surface.

--
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.

Show quoteHide quote

"Kay" <Call***@hotmail.com> wrote in message
news:uQY2QUCIGHA.1032@TK2MSFTNGP11.phx.gbl...
> In production environment, we have a SQL Server which is suppose to be 24
> x 7 up and running. I want some information what is required to look after
> in order to make it available and it's health check.
>
> "Michael Hotek" <m***@solidqualitylearning.com> wrote in message
> news:O2%23ZGHCIGHA.604@TK2MSFTNGP14.phx.gbl...
>> What do you define as an HA DB server?
>>
>> --
>> Mike
>> http://www.solidqualitylearning.com
>> Disclaimer: This communication is an original work and represents my sole
>> views on the subject. It does not represent the views of any other
>> person or entity either by inference or direct reference.
>>
>> "Kay" <Call***@hotmail.com> wrote in message
>> news:eYAPk3BIGHA.3144@TK2MSFTNGP11.phx.gbl...
>>> All,
>>>
>>> Is there some document available for the TO DO List for HA DB Server on
>>> daily, weekly, monthly or periodically.
>>>
>>> It will help me to document these and work smarter.
>>>
>>> TIA
>>> Kay
>>>
>>
>>
>
>