Administrating SQL

Folks,
I am looking a way to better manage my SQL Server environment. Here are my
requirements
1 I need to know used, free and availabe space
2 Utilization of memory and other SQL Server 2000 related resources whether
on weekly average (for example) it's good
3 System spec that running the server.
I can do some kind of scripting to dump everything on one webpage that list
the above info but i would like to find out whether there is already any tool
availabe to ease my administration.
Protype of the display should be something like this
Srv Name Ver RAM(Threshold 2G) Diskspace(threshold 30%) Total Hits(max 300)
A 80.760 1G(Good) 25G out of 50G
235 (good)
Thank you
rupart
Start with
http://www.sql-server-performance.com
"rupart" <rupart@.discussions.microsoft.com> wrote in message
news:D717B8B5-26B0-4320-BC33-9075FF689AA6@.microsoft.com...
> Folks,
> I am looking a way to better manage my SQL Server environment. Here are my
> requirements
> 1 I need to know used, free and availabe space
> 2 Utilization of memory and other SQL Server 2000 related resources
whether
> on weekly average (for example) it's good
> 3 System spec that running the server.
> I can do some kind of scripting to dump everything on one webpage that
list
> the above info but i would like to find out whether there is already any
tool
> availabe to ease my administration.
> Protype of the display should be something like this
> Srv Name Ver RAM(Threshold 2G) Diskspace(threshold 30%) Total Hits(max
300)
> A 80.760 1G(Good) 25G out of 50G
> 235 (good)
> Thank you

Administrating SQL

Folks,
I am looking a way to better manage my SQL Server environment. Here are my
requirements
1 I need to know used, free and availabe space
2 Utilization of memory and other SQL Server 2000 related resources whether
on weekly average (for example) it's good
3 System spec that running the server.
I can do some kind of scripting to dump everything on one webpage that list
the above info but i would like to find out whether there is already any too
l
availabe to ease my administration.
Protype of the display should be something like this
Srv Name Ver RAM(Threshold 2G) Diskspace(threshold 30%) Total Hits(max 300)
A 80.760 1G(Good) 25G out of 50G
235 (good)
Thank yourupart
Start with
http://www.sql-server-performance.com
"rupart" <rupart@.discussions.microsoft.com> wrote in message
news:D717B8B5-26B0-4320-BC33-9075FF689AA6@.microsoft.com...
> Folks,
> I am looking a way to better manage my SQL Server environment. Here are my
> requirements
> 1 I need to know used, free and availabe space
> 2 Utilization of memory and other SQL Server 2000 related resources
whether
> on weekly average (for example) it's good
> 3 System spec that running the server.
> I can do some kind of scripting to dump everything on one webpage that
list
> the above info but i would like to find out whether there is already any
tool
> availabe to ease my administration.
> Protype of the display should be something like this
> Srv Name Ver RAM(Threshold 2G) Diskspace(threshold 30%) Total Hits(max
300)
> A 80.760 1G(Good) 25G out of 50G
> 235 (good)
> Thank you

Administrating SQL

Folks,
I am looking a way to better manage my SQL Server environment. Here are my
requirements
1 I need to know used, free and availabe space
2 Utilization of memory and other SQL Server 2000 related resources whether
on weekly average (for example) it's good
3 System spec that running the server.
I can do some kind of scripting to dump everything on one webpage that list
the above info but i would like to find out whether there is already any tool
availabe to ease my administration.
Protype of the display should be something like this
Srv Name Ver RAM(Threshold 2G) Diskspace(threshold 30%) Total Hits(max 300)
A 80.760 1G(Good) 25G out of 50G
235 (good)
Thank yourupart
Start with
http://www.sql-server-performance.com
"rupart" <rupart@.discussions.microsoft.com> wrote in message
news:D717B8B5-26B0-4320-BC33-9075FF689AA6@.microsoft.com...
> Folks,
> I am looking a way to better manage my SQL Server environment. Here are my
> requirements
> 1 I need to know used, free and availabe space
> 2 Utilization of memory and other SQL Server 2000 related resources
whether
> on weekly average (for example) it's good
> 3 System spec that running the server.
> I can do some kind of scripting to dump everything on one webpage that
list
> the above info but i would like to find out whether there is already any
tool
> availabe to ease my administration.
> Protype of the display should be something like this
> Srv Name Ver RAM(Threshold 2G) Diskspace(threshold 30%) Total Hits(max
300)
> A 80.760 1G(Good) 25G out of 50G
> 235 (good)
> Thank you

Administering SQl 2000 from SQL 2005

I have some old SQL servers that I cannot upgrade becuase of the application
that uses them. Can I manage these servers from SQL 2005? IF so, are there
any known gotchas? Thanks in advance.
--
BettieYou can do all most common tasks using the new 2005 Studio, the "new and
improved" features won't work however
like i.e. Preformance Tunning Wizard.
By the way - I haven't seen any issues with my "legacy" application after
upgrading to 2005 server, as long as you keep
the specific databases on SQL2000's compatibility level (uprgade process
leaves them there by default).
rgrds
rafael
"Bettie Claxton" <BettieClaxton@.discussions.microsoft.com> wrote in message
news:0E984055-B655-4094-91A5-5B45C998545B@.microsoft.com...
>I have some old SQL servers that I cannot upgrade becuase of the
>application
> that uses them. Can I manage these servers from SQL 2005? IF so, are there
> any known gotchas? Thanks in advance.
> --
> Bettie|||No problems. I am using SQL 2005 Management studio to manage couple of my
SQL 2000 servers.
But the other way will not work out...
Thanks
Hari
"Bettie Claxton" <BettieClaxton@.discussions.microsoft.com> wrote in message
news:0E984055-B655-4094-91A5-5B45C998545B@.microsoft.com...
>I have some old SQL servers that I cannot upgrade becuase of the
>application
> that uses them. Can I manage these servers from SQL 2005? IF so, are there
> any known gotchas? Thanks in advance.
> --
> Bettie|||Thanks -- I'll try the upgrade in the lab.
--
Bettie
"Rafael Lenartowicz" wrote:
> You can do all most common tasks using the new 2005 Studio, the "new and
> improved" features won't work however
> like i.e. Preformance Tunning Wizard.
> By the way - I haven't seen any issues with my "legacy" application after
> upgrading to 2005 server, as long as you keep
> the specific databases on SQL2000's compatibility level (uprgade process
> leaves them there by default).
> rgrds
> rafael
>
> "Bettie Claxton" <BettieClaxton@.discussions.microsoft.com> wrote in message
> news:0E984055-B655-4094-91A5-5B45C998545B@.microsoft.com...
> >I have some old SQL servers that I cannot upgrade becuase of the
> >application
> > that uses them. Can I manage these servers from SQL 2005? IF so, are there
> > any known gotchas? Thanks in advance.
> > --
> > Bettie
>
>

Administering SQl 2000 from SQL 2005

I have some old SQL servers that I cannot upgrade becuase of the application
that uses them. Can I manage these servers from SQL 2005? IF so, are there
any known gotchas? Thanks in advance.
Bettie
You can do all most common tasks using the new 2005 Studio, the "new and
improved" features won't work however
like i.e. Preformance Tunning Wizard.
By the way - I haven't seen any issues with my "legacy" application after
upgrading to 2005 server, as long as you keep
the specific databases on SQL2000's compatibility level (uprgade process
leaves them there by default).
rgrds
rafael
"Bettie Claxton" <BettieClaxton@.discussions.microsoft.com> wrote in message
news:0E984055-B655-4094-91A5-5B45C998545B@.microsoft.com...
>I have some old SQL servers that I cannot upgrade becuase of the
>application
> that uses them. Can I manage these servers from SQL 2005? IF so, are there
> any known gotchas? Thanks in advance.
> --
> Bettie
|||No problems. I am using SQL 2005 Management studio to manage couple of my
SQL 2000 servers.
But the other way will not work out...
Thanks
Hari
"Bettie Claxton" <BettieClaxton@.discussions.microsoft.com> wrote in message
news:0E984055-B655-4094-91A5-5B45C998545B@.microsoft.com...
>I have some old SQL servers that I cannot upgrade becuase of the
>application
> that uses them. Can I manage these servers from SQL 2005? IF so, are there
> any known gotchas? Thanks in advance.
> --
> Bettie
|||Thanks -- I'll try the upgrade in the lab.
Bettie
"Rafael Lenartowicz" wrote:

> You can do all most common tasks using the new 2005 Studio, the "new and
> improved" features won't work however
> like i.e. Preformance Tunning Wizard.
> By the way - I haven't seen any issues with my "legacy" application after
> upgrading to 2005 server, as long as you keep
> the specific databases on SQL2000's compatibility level (uprgade process
> leaves them there by default).
> rgrds
> rafael
>
> "Bettie Claxton" <BettieClaxton@.discussions.microsoft.com> wrote in message
> news:0E984055-B655-4094-91A5-5B45C998545B@.microsoft.com...
>
>

Administering SQl 2000 from SQL 2005

I have some old SQL servers that I cannot upgrade becuase of the application
that uses them. Can I manage these servers from SQL 2005? IF so, are there
any known gotchas? Thanks in advance.
--
BettieYou can do all most common tasks using the new 2005 Studio, the "new and
improved" features won't work however
like i.e. Preformance Tunning Wizard.
By the way - I haven't seen any issues with my "legacy" application after
upgrading to 2005 server, as long as you keep
the specific databases on SQL2000's compatibility level (uprgade process
leaves them there by default).
rgrds
rafael
"Bettie Claxton" <BettieClaxton@.discussions.microsoft.com> wrote in message
news:0E984055-B655-4094-91A5-5B45C998545B@.microsoft.com...
>I have some old SQL servers that I cannot upgrade becuase of the
>application
> that uses them. Can I manage these servers from SQL 2005? IF so, are there
> any known gotchas? Thanks in advance.
> --
> Bettie|||No problems. I am using SQL 2005 Management studio to manage couple of my
SQL 2000 servers.
But the other way will not work out...
Thanks
Hari
"Bettie Claxton" <BettieClaxton@.discussions.microsoft.com> wrote in message
news:0E984055-B655-4094-91A5-5B45C998545B@.microsoft.com...
>I have some old SQL servers that I cannot upgrade becuase of the
>application
> that uses them. Can I manage these servers from SQL 2005? IF so, are there
> any known gotchas? Thanks in advance.
> --
> Bettie|||Thanks -- I'll try the upgrade in the lab.
--
Bettie
"Rafael Lenartowicz" wrote:

> You can do all most common tasks using the new 2005 Studio, the "new and
> improved" features won't work however
> like i.e. Preformance Tunning Wizard.
> By the way - I haven't seen any issues with my "legacy" application after
> upgrading to 2005 server, as long as you keep
> the specific databases on SQL2000's compatibility level (uprgade process
> leaves them there by default).
> rgrds
> rafael
>
> "Bettie Claxton" <BettieClaxton@.discussions.microsoft.com> wrote in messag
e
> news:0E984055-B655-4094-91A5-5B45C998545B@.microsoft.com...
>
>