This article explains that how can we improve the performance when we access the SQL Query via network.
Scenario: I have taken SQL Server installed on Virtual Machine with 7GB of RAM and accessing the SQL Server database from local SQL Server management studio.
Step 1: Up and Run VM with SQL Server installed.
Step 2: Enable the DNS name of the Virtual Machine.
Step 3: Enable the TCP port with 1433 in portal.
Step 4: Create TCP port inside virtual Machine. Type WF.msc in command prompt. Right click on Inbound Rules and choose New.
Step 5: Make sure SQL Server services are up and running.
Step 6: Enable the SQL Server as mixed mode authentication.
Step 7: Create a new user login and check.
Step 8: Access the database from local SSMS.
Performance Improvement with NitroAccelerator
Install the “NitroAccelerator” in local machine, http://nitrosphere.com/trial/?ref=83095
Step 2: Run the query in local SSMS without Nitro Accelerator.
Step 3: Start the accelerator and test the query performance.