Solved

SQL perfomance/issues Horizon View 5.3

Posted on 2014-04-11
2
474 Views
Last Modified: 2014-04-30
Good Morning,
I am seeing some performance issue with Vmware view composer talking to my MS SQL 2008 (Enterprise), the symptoms are:

5 to 35 minutes for recompose of linked clones to register and begin (5 when no one is on, 35 to an hour when under pressure, I suspect SQL performance perhaps, I have plenty of View Connector servers (4) for 400 vdi sessions, and composer is on a hefty box (8 core with 16gb ram) so not sure that is an issue? Any idea's?
0
Comment
Question by:Jonathan Jones
2 Comments
 
LVL 19

Expert Comment

by:compdigit44
ID: 39997808
-Is this a new issue or have it been slowly building over time?
-Any changes to your infrastructure lately?
-What are the memory, CPU and storage stats on your SQL server?
-Are any backups running on the SQL server when user are experience slow response times?
-Any error on the Event logs on the SQL servers?
-Does the SQL server host DB's for other applications?
-How many NIC's does the server have and what is their speed?
-Did you check your uplink switch for errors?
0
 
LVL 8

Accepted Solution

by:
ProjectChampion earned 500 total points
ID: 40006135
Try identifying where the the most of time is spent. It could be as you suspect a SQL Server performance issue, but it is also possible to be a VM issue.
If it's a SQL Server performance issue, try to find out what's going on on the server. For instance using SQL Activity monitor you can instantly see if there are any blocked processes or excessive wait times. You can also try finding out what exactly is going on in the database by setting up a trace in SQL Profiler.

There may be virtually countless potential culprits at different layers for instance:
1. Concurrency issues at the application level
2. Resource issues including Disk, I/O subsystem, RAM, CPU
3. SQL Server settings and configurations
4. Database issues including fragmented, missing or inefficient indexes or even too many indexes...

In reality most of the performance issues are result of multiple factors, so it is important that you identify the major contributors and prioritize and focus your optimization efforts to get the best result. Of course most performance issues can be resolved or at least improved by throwing more RAM and better disk and CPU at them, but you may as well find that your problem has been caused by a couple of missing indexes or a missing maintenance plan or a table that has grown too large and just need partitioning.


Good luck with your quest.
0

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

Will try to explain how to use the VMware feature TAGs in the VMs and create Veeam Backup Jobs using TAGs. Since this article is too long, I will create second article for the Veeam tasks.
HOW TO: Install and Configure VMware vSphere Hypervisor 6.5 (ESXi 6.5), Step by Step Tutorial with screenshots. From Download, Checking Media, to Completed Installation.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

760 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

23 Experts available now in Live!

Get 1:1 Help Now