MIS Systems Thread, SIMS Performance in Technical; We have just upgraded from SQL 2005 Express to the Enterprise Edition and i haven't really found much difference with ...
4th November 2008, 04:12 PM #1
We have just upgraded from SQL 2005 Express to the Enterprise Edition and i haven't really found much difference with the performance and running of SIMS. We have a sexy HP server with a high spec The Lan is more-less all running on 1000MB with fibre switches.
Are there any tweaks i could do to SQL 2005 ? (what are your settings?)
Any SIMS files that could be tweaked?
4th November 2008, 06:46 PM #2
I wouldn't expect upgrading to Enterprise to yield much extra performance on its own. I think the big performance indicators for a database will be how well the actual database structure is normalised (hint: in SIMS, the answer is 'not very'), the actual size of the DB, whether it has indexes built for the right keys; all things you don't have much control over unless you fancy some completely unsupported tinkering with the DB schema, which would probably give Capita a heart attack if they caught you doing it, and break SIMS horribly if you mess it up.
After that, you're looking at the server hardware (which you haven't changed) and possibly the client-side application performance (again, not something you can tweak much).
4th November 2008, 07:12 PM #3
Check you haven't got any realtime virus scan running on the database. Also, try specifically allocating memory to the SQL server helps. Another one is if you have more than 3Gb of memory you can get SQL to use it if you are on a 32-bit server. At home and can't remember exactly how to do it, but a google search should tell you.
4th November 2008, 08:47 PM #4
Read on some Capita Docs a while back about not Virus Scanning the S: drive; speeds up load times of SIMS a bit.
5th November 2008, 08:57 AM #5
This could be to do with a number of things.
sims.net it is quite resource demanding, what is the spec of the server.
also check what processes are running, CPU usage or how much sims.net is taking up.
You may find if you increase the virtual memory this will increase the performance.
hope this is of any help.
to stop any processes from starting in task manager just go
Start | run | msconfig.
5th November 2008, 09:13 AM #6
32bit your limited to 3GB really, assuming your MSSQL is config'd to use it all. I would look at 64bit. PM if you (or anyone) wants a SQL defrag script for SIMS.
5th November 2008, 09:23 AM #7
If your with Capita though they do not support the 64bit platform PC's
So be wary of this, and also could cause problems launching 16it prgrams, I beleive that you would need to install something to get this running.
As even in compatibility mode this will not run.
I presume your server is Windows server 2003???
5th November 2008, 09:24 AM #8
Actually you are not, see Enabling AWE Memory for SQL Server
Originally Posted by matt40k
5th November 2008, 09:25 AM #9
. The problem is that up to now SIMS does not support 64-bit OS's, even on the server, but I beleive this is about to change with the November release.
Originally Posted by teejay
5th November 2008, 09:36 AM #10
As of yet Sims is not tested on 64bit platforms.
But I haven't heard of anyone supporting 64bit from november although if you install Installing ADPS on 64-bit server. this will enable you to use 16bit programs
5th November 2008, 09:38 AM #11
Capita support x64 SIMS from Aug'08, in Nov they will support x64 FMS. Check the roadmap teejay (resource 13512)
32bit is limited to 4GB hardcoded. You can extend it, but lets face it, it's pretty bug filled. Your also limited to how much you can give to 32bit applications. Again, it's the limits of 32bit.
5th November 2008, 09:44 AM #12
Installing ADPS will still allow you to user 16bit programs on Vista and 64bit platforms
5th November 2008, 10:02 AM #13
I'm going to be very vague with this post - as my memory seems to be useless today....
But from what I can remember the biggest performance increase that would probably help is that SQL Express 2005 has something like a maximum of 8 user connections. Whereas the Enterprise edition should allow you to set the number of connections you require.
If your old SQL Express 2005 was hitting its connection limit it would queue the requests and cause slow down.
So vague answer might be to check how to configure for more connections....
Or it might be nothing to do with that....
5th November 2008, 10:16 AM #14
sql express 2005 is only limited one cpu and 1GB RAM and 4GB DB, it doesn't have any other restrictions.
5th November 2008, 10:23 AM #15
You are correct.... my memory is very bad!
Microsoft SQL Server 2005: Compare Features
By mattx in forum Wireless Networks
Last Post: 8th August 2007, 05:25 PM
By tomscaper in forum Windows
Last Post: 24th May 2007, 10:27 PM
By webman in forum ICT KS3 SATS Tests
Last Post: 23rd May 2006, 07:53 PM
By faza in forum Hardware
Last Post: 23rd May 2006, 07:31 AM
By barryfl in forum MIS Systems
Last Post: 14th March 2006, 11:52 AM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)