I’m looking for some feedback from your experience with system performance when doing a lot of development work.
We are currently building our Self Service System (not powered by Service Catalogue) and are finding Console (7.6.1), which we only use for design work incredibly slow!
What would you say is your average wait for saving an Object, Window, Query etc? We were seeing consistent waits of 2 minutes no matter what the type of save is and then all of a sudden today this has jumped up to just under 5 minutes on just about every save!
Our database has the following usage currently:
- 10GB Data File (2.5GB Unused) (MDF File)
- 15GB Transaction Log File (LDF File)
We have checked for Unbound Collections and found no issues and the DB Server health (CPU, RAM, Utilisation, Network Connection etc) is "Exceptional" according to our DBA’s. We also have Snapshot Isolation running.
On the TPS Server health front this is normal and has the below setup with plenty of resources available under the hood:
- Windows Server 2008 R2 Standard (Service Pack 1)
- VMware Virtual Platform
- x64-based PC
- 1 Processor Installed (AMD64 Family 16 Model 4 Stepping 2 Authentic AMD ~2700 Mhz)
- 8GB RAM
- Services & Web Running on the same host which is fine in Dev
These waits may be normal but trying to do a big project is incredibly time consuming and frustrating!
Our DBA’s have captured some Perfmon Stats & Run a SQL Trace which will be analysed when they have available time hopefully early next week using RML Utilities and SQL Nexus.
Fingers crossed someone maybe has the magic answer to ending this nightmare for us or can shed some light on the issue.
After the DBA’s have checked the traces I will raise this with LANDesk Support but I don’t really know if this is normal currently.
Thanks & Kindest Regards,