Monitor server

I plan to create a Monitor server to monitor tasks. My goal is to avoid
using the data servers (5 servers) to perform tasks.
Some of the tasks are log shipping, generate reports, run batch file and add
users.
What is some to the drawback of using the Monitor Server?
Can Monitor Server managing users from other servers?
Any suggestions would be greatly apprecated,
Culam
"culam" <culam@.discussions.microsoft.com> wrote in message
news:D1A477E7-B9BB-4558-A8C2-A4F04D377832@.microsoft.com...
> I plan to create a Monitor server to monitor tasks. My goal is to avoid
> using the data servers (5 servers) to perform tasks.
> Some of the tasks are log shipping, generate reports, run batch file and
add
> users.
> What is some to the drawback of using the Monitor Server?
> Can Monitor Server managing users from other servers?
> Any suggestions would be greatly apprecated,
> Culam
>
|||It is better to have a monitor server which is independent of the production
servers it is monitoring...That's good.
There is no Microsoft single interface which will allow you to add users to
multiple servers, if that is what you are asking for... You could write your
own sp or interface, but I think there are probably some 3rd party tools
which may do this for you... ( Embarcadero used to have a tool for DBAs
which did this kind of thing.)
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"culam" <culam@.discussions.microsoft.com> wrote in message
news:D1A477E7-B9BB-4558-A8C2-A4F04D377832@.microsoft.com...
> I plan to create a Monitor server to monitor tasks. My goal is to avoid
> using the data servers (5 servers) to perform tasks.
> Some of the tasks are log shipping, generate reports, run batch file and
add
> users.
> What is some to the drawback of using the Monitor Server?
> Can Monitor Server managing users from other servers?
> Any suggestions would be greatly apprecated,
> Culam
>

Monitor server

I plan to create a Monitor server to monitor tasks. My goal is to avoid
using the data servers (5 servers) to perform tasks.
Some of the tasks are log shipping, generate reports, run batch file and add
users.
What is some to the drawback of using the Monitor Server?
Can Monitor Server managing users from other servers?
Any suggestions would be greatly apprecated,
Culam"culam" <culam@.discussions.microsoft.com> wrote in message
news:D1A477E7-B9BB-4558-A8C2-A4F04D377832@.microsoft.com...
> I plan to create a Monitor server to monitor tasks. My goal is to avoid
> using the data servers (5 servers) to perform tasks.
> Some of the tasks are log shipping, generate reports, run batch file and
add
> users.
> What is some to the drawback of using the Monitor Server?
> Can Monitor Server managing users from other servers?
> Any suggestions would be greatly apprecated,
> Culam
>|||It is better to have a monitor server which is independent of the production
servers it is monitoring...That's good.
There is no Microsoft single interface which will allow you to add users to
multiple servers, if that is what you are asking for... You could write your
own sp or interface, but I think there are probably some 3rd party tools
which may do this for you... ( Embarcadero used to have a tool for DBAs
which did this kind of thing.)
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"culam" <culam@.discussions.microsoft.com> wrote in message
news:D1A477E7-B9BB-4558-A8C2-A4F04D377832@.microsoft.com...
> I plan to create a Monitor server to monitor tasks. My goal is to avoid
> using the data servers (5 servers) to perform tasks.
> Some of the tasks are log shipping, generate reports, run batch file and
add
> users.
> What is some to the drawback of using the Monitor Server?
> Can Monitor Server managing users from other servers?
> Any suggestions would be greatly apprecated,
> Culam
>

Monitor server

I plan to create a Monitor server to monitor tasks. My goal is to avoid
using the data servers (5 servers) to perform tasks.
Some of the tasks are log shipping, generate reports, run batch file and add
users.
What is some to the drawback of using the Monitor Server?
Can Monitor Server managing users from other servers?
Any suggestions would be greatly apprecated,
Culam"culam" <culam@.discussions.microsoft.com> wrote in message
news:D1A477E7-B9BB-4558-A8C2-A4F04D377832@.microsoft.com...
> I plan to create a Monitor server to monitor tasks. My goal is to avoid
> using the data servers (5 servers) to perform tasks.
> Some of the tasks are log shipping, generate reports, run batch file and
add
> users.
> What is some to the drawback of using the Monitor Server?
> Can Monitor Server managing users from other servers?
> Any suggestions would be greatly apprecated,
> Culam
>|||It is better to have a monitor server which is independent of the production
servers it is monitoring...That's good.
There is no Microsoft single interface which will allow you to add users to
multiple servers, if that is what you are asking for... You could write your
own sp or interface, but I think there are probably some 3rd party tools
which may do this for you... ( Embarcadero used to have a tool for DBAs
which did this kind of thing.)
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"culam" <culam@.discussions.microsoft.com> wrote in message
news:D1A477E7-B9BB-4558-A8C2-A4F04D377832@.microsoft.com...
> I plan to create a Monitor server to monitor tasks. My goal is to avoid
> using the data servers (5 servers) to perform tasks.
> Some of the tasks are log shipping, generate reports, run batch file and
add
> users.
> What is some to the drawback of using the Monitor Server?
> Can Monitor Server managing users from other servers?
> Any suggestions would be greatly apprecated,
> Culam
>

Monitor Database Growth

At the present moment, is there any software in-place to give us the ability
to perform database growth monitoring, database sizes. charts etc.
thanks
Farrukh"FARRUKH" <farrscorpio77@.hotmail.com> wrote in message
news:3E4CD58C-736D-4F35-A574-1FE52DEBB25D@.microsoft.com...
> At the present moment, is there any software in-place to give us the
> ability
> to perform database growth monitoring, database sizes. charts etc.
> thanks
> Farrukh
The performance monitor in Windows will have SQL Server specific objects and
counters in it. Take a look at these counters.
Rick Sawtell|||Hi
Take a look into
dbname.sys.database_files system table
"FARRUKH" <farrscorpio77@.hotmail.com> wrote in message
news:3E4CD58C-736D-4F35-A574-1FE52DEBB25D@.microsoft.com...
> At the present moment, is there any software in-place to give us the
> ability
> to perform database growth monitoring, database sizes. charts etc.
> thanks
> Farrukh