SQL Server Environment - VMware or Physical?

patrick_bisaillon@gov.nt.ca

Hi there,

We are trying to determine the root cause of a lot of SQL performance issues that we’ve been experiencing which is causing a lot of issue. When there is any kind of load on the SQL server, there are numerous deadlocks and waiting tasks thus resulting in SQL statements getting dropped (entries not being made in tables – orphaned documents), long wait times for Content Server users when browsing/saving/etc.. and overall poor application performance. When these issues are occurring, the CPU on the SQL server appears to be normal, and there is free memory as well. The issue is it seems like the SQL server cannot keep up with the amount of tasks coming in and cannot process them fast enough. When we upgraed to CS10 from 9.7.1 we noticed a huge impact on the SQL server (facets, agents, etc..) I'm trying to determine if the issue is because we are running our SQL server in a shared VMware environment?

Can you respond with what your SQL Server specs are? and whether you are running in a VMware enviornment? Also, can anybody from Open Text also respond with any suggestions/reccomendations?

Thanks,

Patrick Bisaillon

Find more posts tagged with

Comments

Kyle_Swidrovich

Had quick chat with our performance folks...

Are you using snapshot isolation? If not, you should be.
Also, make sure your tempdb is not on virtual disk (pv-SCSI would likely result in the best performance).

patrick_bisaillon@gov.nt.ca

Hi Kyle,

thanks for the info. Just wondering what snapshot levels you are referring to? Should only Snapshot be enabled? Or should "Read Committed Snapshot Isolation" also be enabled? This is our current setting:

snapshot_isolation_state: 0
snapshot_isolation_state_desc: OFF
is_read_committed_snapshot_on: 0

Thanks again,

Patrick

Kyle_Swidrovich

Hi Patrick,

Have a look at David Templeton’s response in this thread:

https://knowledge.opentext.com/knowledge/cs.dll?func=ll&objId=35368748&objAction=viewincontainer&ShowReplyEntry=39391980#forum_topic_39391980

As per his response, both should be enabled.

Cheers,

Kyle