| Mike Epprecht \(SQL MVP\) 2005-09-10, 3:23 am |
| Hi
EM does not consume more resources than a normal client application
connection to SQL Server.
As long as you don't use the "open table" to look at data, you are fine.
Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Alwin Mark" <AMark_SFO@hotmail.com> wrote in message
news:eygY6GatFHA.2472@TK2MSFTNGP14.phx.gbl...
> If the Enterprise Manger is running and the registered servers will be
> resource consuming issue for the server. We have couple of developers
> connected to the server all the time using EM.
>
> Lately I read an article on Management Studio for SQL Server 2005 which
> handles this issue.
>
> How much it is contributing to the resources usage of SQL Server? I am
> thinking all possible way to improve the performance of our SQL Server.
>
> Thank you,
>
> Alwin
>
>
|