?
Solved

SQL perfomance/issues Horizon View 5.3

Posted on 2014-04-11
2
Medium Priority
?
509 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 20

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 2000 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

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
In this blog, we’ll look at how improvements to Percona XtraDB Cluster improved IST performance.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
This Micro Tutorial walks you through using a remote console to access a server and install ESXi 5.1. This example is showing remote access and installation using a Dell server. The hypervisor is the very first component of your virtual infrastructu…
Suggested Courses

777 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