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?
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).
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.
Read on some Capita Docs a while back about not Virus Scanning the S: drive; speeds up load times of SIMS a bit.
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. :censored:
hope this is of any help.
to stop any processes from starting in task manager just go
Start | run | msconfig.
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.
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???
Actually you are not, see Enabling AWE Memory for SQL Server
Originally Posted by matt40k
. 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
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 :cool:
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.
Installing ADPS will still allow you to user 16bit programs on Vista and 64bit platforms :)
I'm going to be very vague with this post - as my memory seems to be useless today.... :doh:
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.... :D
sql express 2005 is only limited one cpu and 1GB RAM and 4GB DB, it doesn't have any other restrictions.
You are correct.... my memory is very bad!
Microsoft SQL Server 2005: Compare Features