Sunday, February 26, 2012

EM and the Resource consumption.....

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,
AlwinHi
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
>

No comments:

Post a Comment