November 3, 2011 at 2:05 pm
Is there any "best practices" guidance regarding routinely connecting to a SQL Server machine via Remote Desktop to do Mgmt Studio work vs. a "normal" running of SSMS from a network workstation?
I'm referring to regular SSMS work that could be done via a workstation, not some server-specific maintenance work.
Just curious as to whether running directly consumes more server resources, or otherwise negatively impacts the normal operation of the server machine.
Many thanks~
November 3, 2011 at 2:10 pm
Anything running on a computer consumes memory and CPU, and often I/O. This includes SSMS.
Eddie Wuerch
MCM: SQL
November 3, 2011 at 2:25 pm
Granted, and perhaps it's an unfair question.
I realize there are a zillion variables, but in general, let's say a person has to run queries or create tables, and could do so from a network workstation, but chooses to do it by remote connection to the server. It's obviously faster for that user, but is it likely the performance of other SQL Server users running SSMS on their desktops would be noticeably reduced?
In both cases, the server has to perform db processing; I just don't know how much of what processing is done by the desktop and what is done by the server. If the desktop just deals with display, then I suppose the server isn't doing that much more and overall impact would be negligible.
November 3, 2011 at 3:54 pm
Here's a (very likely) scenario to think about: the user remotes onto the SQL server and launches SSMS. They then issue a query that SELECTs a few million rows or so from a database. SQL Server will grab those rows and send them to the client (SSMS) which will need to borrow more memory from the client OS in order to load and display the result set...and if there are a lot of rows, that can translate to a lot of RAM. And remember, in this case, the client machine is going to be the server! Personally, if a user issues a massive SELECT that results in SSMS running out of memory, I'd rather it trash their personal workstation than my production database server. 😀
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply