Monthly Archives: November 2011

Share your local drives with a Remote Desktop Connection

Have you ever wished there was a way to share your local drive with an Remote Desktop Connection? I have, especially when a client doesn’t have a test box.  For example, lets say I need to do a perfmon trace for performance tuning.  I would usually use the PAL Tool to generate a perfmon template and copy it from my machine to the server to configure the trace.  Once the perfmon collection is finished I would want to copy the template back down to my individual machine to generate the PAL reports.

This lead me to do some research and I found an easy solution that works.  Hopefully, this tip helps you out in the future.

Time For The Good Stuff…

Load your Remote Desktop Connection tool and enter in your computer name for the server.  For this example I am going to keep the computer name and user name blank.  Now click on the options button in the lower right corner of the RDC screen.

Remote Desktop Connection initial screen

Type in your computer name and user name for your Remote Desktop Connection.  Once your computer name and user name are entered click on the local resources tab.

Share local drive with Remote Desktop Connection

Now that we are on the local resources tab click on the “More” button shown at the bottom left corner of the screen.

Share local drive with Remote Desktop Connection

Select the local drives you would like to share with your Remote Desktop Connection. In this example I am only going to share my C drive.

The following screen shot will show you that I am sharing my local C drive on the Remote Desktop Connection.

WVPASS – Performance Tuning for Pirates!

If you are in the Pittsburgh, PA area take a trip down to Wheeling, WV this Thursday to catch me at the WVPASS SQL Server User Group.  Registration is free and there  are a few free seats available.  I will be breaking out a brand new presentation titled “Performance Tuning for Pirates.”

Abstract

If you follow baseball you will notice that my favorite team the Pittsburgh Pirates has to do more with less to be successful. Working as a consultant, I have also noticed this trend with several IT shops. If you need to improve the performance of SQL Server and cannot purchase 3rd party tools this session is for you.  I will help improve your performance tuning process while using several free tools. Through this presentation we will go over wait stats, dynamic management objects, perfmon, PAL, SQL Trace, ClearTrace, SQL Nexus and  SQLDiag.