Solved

Performance using RDS under Windows Server 2008 R2

Posted on 2016-08-21
9
74 Views
Last Modified: 2016-08-25
I've been promoting the idea of remote access to a major client for a number of years and now, all of a sudden, they are really interested in the idea and now I'm having second thoughts and feeling a little overwhelmed.  I have it set up on my own network and it works well except when the end-user attempts to "dump" one of my larger reports to an Excel file on their local system.  This process takes forever (if it even completes) and I'd like to find out if anyone can suggest a solution to make this process any faster?  More RAM, faster bandwidth, etc.?
0
Comment
Question by:Jim Klocksin
9 Comments
 
LVL 27

Expert Comment

by:davorin
ID: 41764423
"dump" means save?
If that is the case, then faster bandwidth can help. You can try to connect to RDS from the computer in the same LAN and save the excel file. You probably have 1Gbps at your LAN.
0
 
LVL 95

Expert Comment

by:Lee W, MVP
ID: 41764426
Agreed - your description of "dump" is lacking.  You need to explain what you've got now before you start throwing resources at it... and then start looking at your performance statistics... Have you checked how much bandwidth is used when "dumping"?  Is it the maximum you can upload or the maximum they receive?  How is the RAM utilization in Excel - have you looked at task manager?  How is the CPU utilization?
0
 
LVL 9

Accepted Solution

by:
bas2754 earned 250 total points
ID: 41764429
It sounds like the client might be trying to save the file to the local computer via RDS mapped drives? If that is the case then the only solution is faster bandwidth on both ends.  Upload speed on the server side and download speed on the client side are the limiting factors for this specific operation.

I do know that performance is a bit slow savingor copying files via the RDS drives.   We solved this for one client by having them save the files locally to a share on a server in the data center or even the RDS server itself and then they copied the file via and SMB mapping over a VPN.   This allowed the file to process quickly as it was all local access and then the file copy operation was fairly quick.   This is probably due to the fact the copy is a straight write operation to the client rather that having a full file access for the export operationd from  Excel.

Let us know if that helps or you need more assistance.
0
 
LVL 78

Expert Comment

by:David Johnson, CD, MVP
ID: 41764454
What is your up/down bandwidth? When you say 'dump' what do you mean exactly? Export from a report on your system into their excel? What is your disk subsystem?  Memory available and cpu?

All of these disk/memory/cpu/network are variables.. and you need to have sufficient resources.
0
Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

 

Author Comment

by:Jim Klocksin
ID: 41765434
So everyone seems to concur that bandwidth is my main obstacle here and my Comcast upload speed is not good.  The basic program runs with decent throughput but, as I said, my "save file/report to an Excel spreadsheet" is a dog with the bandwidth I currently have.  I'm probably going to "host" this application on a third-party company's equipment and their bandwidth will be substantially better.  At this point, I'm preparing for a meeting with my client, actually all the contacts that are pushing for this "remote" access option, and just want to have some answers to provide them with a credible proposal.  I'm still researching and will check out some of the specific suggestions all of you have provided, but I need a definitive sign-off by my client (and their IT staff) before I actually take this to the next step.  Thanks for all the input!  I'd like to keep this question open for a few more days in case I have any other areas of concern...
0
 
LVL 95

Expert Comment

by:Lee W, MVP
ID: 41765616
Actually, everyone seems to concur we don't know what you mean by DUMP.

We SUSPECT it has something to do with bandwidth, but you haven't taken the time to explain it or how the application/RDS design is implemented.
0
 

Author Comment

by:Jim Klocksin
ID: 41770353
I really don't know how to explain it any better than in my comment above.  My application contains numerous reports.  I provide the user the option of printing each report, saving the report as a PDF file, or saving the "raw data" from the report into an Excel spreadsheet.  

Additionally, I need to provide my client with an estimate for the cost of setting up my application as a "hosted" application running on a dedicated server using a hosting company such as Rackspace.  This is really where my original question was heading.  I've read a number of articles, blogs, etc. in order to estimate my hardware requirements and have concluded (for the moment) that a 64GB solution from Rackspace should suffice (based on 100 concurrent users, small database sizes, and running the Windows Server 2008 R2 OS, SQL Server 2008 R2, AD, and Remote Desktop Services on the same server).  I'm attaching a screenshot from their website that provides more detail on their specifications.  I'm running a single application as a RemoteApp, which runs adequately on my own network on a 16GB (RAM) server.  Any and all feedback would be greatly appreciated as this is a major departure for my client who runs everything "in-house" currently, but whose end-users are desperate for a remote solution:Dedicated Server options from Rackspace web site
0
 
LVL 95

Assisted Solution

by:Lee W, MVP
Lee W, MVP earned 250 total points
ID: 41770494
So you have an application that we have no idea what it does other than export to Excel.

We have no idea how big this "dump" is.  Is it 32 KB or 32 MB? Larger?  Somewhere in between?  What is the TYPICAL size.

We don't know what your upload speeds are.

We don't know what your client's download speeds are.

I at least have asked about and have not yet been provided with:
Have you checked how much bandwidth is used when "dumping"?  
How is the RAM utilization in Excel?  
How is the CPU utilization?

We also don't know if you configured this in a VM.

We need more information if you want a quick response that can put you on the right track.

"Dump" related details such as size and bandwidth and how they are dumping locally would help!
0
 

Author Closing Comment

by:Jim Klocksin
ID: 41770680
I'm sorry but I need to move on.  I'm convinced by all the above comments that bandwidth is my primary obstacle (which is essentially what I thought before I even asked the question).  I'm going to start a new question "thread" based on my last comment which is really where I need some assistance in order to prepare for a meeting with representatives of my client.  Thanks for all of your input and I'm sorry if the term "dump" created so much confusion.  As I said in my last comment, "dump" was just the way I refer to saving information (whatever the volume) from my application's reports to an Excel spreadsheet.
0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Possible fixes for Windows 7 and Windows Server 2008 updating problem. Solutions mentioned are from Microsoft themselves. I started a case with them from our Microsoft Silver Partner option to open a case and get direct support from Microsoft. If s…
To efficiently enable the rotation of USB drives for backups, storage pools need to be created. This way no matter which USB drive is installed, the backups will successfully write without any administrative intervention. Multiple USB devices need t…
This tutorial will walk an individual through configuring a drive on a Windows Server 2008 to perform shadow copies in order to quickly recover deleted files and folders. Click on Start and then select Computer to view the available drives on the se…

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now