Memory Impact when multiple server registered

happygv · March 1st, 2007, 08:04 AM

Hi,

Did someone research on the memory impact on sql server, which has got multiple other sql servers registered in the EM? Does it affect the performance in any ways? Is there a pointer on the net to know how registering multiple remote sql servers on EM impacts on the sql server itself?

Let me know here, if any of you came across this.
Cheers

_________________________
- Vijay G
Strive for Perfection

robprell · March 1st, 2007, 01:35 PM

I would like to help you, did a lot of memory research with SQL server but what do are you referring to by "EM"?

happygv · March 1st, 2007, 03:38 PM

EM = Enterprise Manager, sorry about using short forms.

Curious to se your reply.

Cheers,

_________________________
- Vijay G
Strive for Perfection

robprell · March 1st, 2007, 05:10 PM

registration of SQL servers on the client computer doesn't affect the server at all. In fact the server doesn't even know about them. Does this help?

happygv · March 1st, 2007, 06:42 PM

Thanks for the reply. Is there anywhere I can read something related to that?

Cheers

_________________________
- Vijay G
Strive for Perfection

robprell · March 1st, 2007, 08:14 PM

Well you can understand what the SQL server is doing when you register it by using query profiler. Run Query profiler on a server nobody is using. Then register the enterprise manager on a clinet and look at what sql it generates. Thats all that happens when you register the server on the servers side.

happygv · March 2nd, 2007, 11:01 AM

But does it not keep probing the client periodically to know its status? I assume so. Let me check that with the profiler too.

_________________________
- Vijay G
Strive for Perfection

happygv · March 2nd, 2007, 11:11 AM

Yes, you are right, I see no impact of it on the sql server when added with more such clients.

Thanks

_________________________
- Vijay G
Strive for Perfection

robprell · March 2nd, 2007, 01:53 PM

registration client side connects to the sql server (one time hit) then after that never touches the server again unless you launch enterprise manager. Launching enterprise manager can try to connect to the server and that would put a load on the server. But if you install enterprise manager on 1000 computer but never launch them on the client ever again there will be zero load on the server.

happygv · March 8th, 2007, 09:28 AM

Yes that was my question... I keep my EM open on the server that has got 10 or 15 other servers registered. Does that keep trying to probe all those 10 or 15 servers registered in the EM to know its status periodically?

_________________________
- Vijay G
Strive for Perfection