Sims.net Server2008 64Bit

[MACIT]

Im looking at moving our current 2003 R2 32Bit setup over to a 2008 x64 Enterprise Server.

Has anyone done this yet as so far im not getting very far. siminst runs ok but does not "see" the 64Bit install of SQL2005, All i get is a drop down option offering a 32bit instance.

Any pointers appreciated?

[techyphil]

yup i done it 7 days ago. Well .ICT did it for me. I moved SIMS from Win2k3 R2 32bit to Win2k8 64bit running MSSQL2005 64bit.

We've got 12GB RAM installed in this box and SQL has gobbled up 10GB

[matt40k]

Make sure you have the latest Setups directory (SIMSINST), install MSSQL first, then run the installer (SIMSINST).

Just remember Nova-T, Exams and other old bits won't work. If you're going 64bit, you might as well get Full MSSQL otherwise you're limiting yourself to 1GB.

[rasssp]

nova t and exams? both dont work on sql 2005 x64?

Is that nova t 4 or 6? or both

[FN-GM]

I was under the impression you would only get problems if you are actually running them on a 64 bit client. All the server holds is the database and files, you wont be running the software on there.

[rasssp]

Capita have told us we may need to goto sql enterprise as our db has outgrown the standard version.

Also discussing the move to 2k3 x64 and sql 2005 x64.

Any one have a list of advantages and disadvantages?

[matt40k]

Nova-T4 is 16bit... not checked 6... I assume 32bit.

I was under the impression you would only get problems if you are actually running them on a 64 bit client. All the server holds is the database and files, you wont be running the software on there.

Correct, however when you get a problem you generally want to test it on the server, first thing that springs to mind to Exams when you import results (otherwise you end up manually splitting the file up).

You might also want to make your SIMS Support aware, just so they don't remote-in to the server, but the client.

[matt40k]

Capita have told us we may need to goto sql enterprise as our db has outgrown the standard version.

Also discussing the move to 2k3 x64 and sql 2005 x64.

Any one have a list of advantages and disadvantages?

64bit will have (software) problems, however generally I (personally) find about 15% performance increase.

[Theblacksheep]

Kent in particular have said they dont support 64bit.

[Oops_my_bad]

Capita have told us we may need to goto sql enterprise as our db has outgrown the standard version.

Any one have a list of advantages and disadvantages?

I doubt very much you have a database size in excess of 4GB - we are a large school and dont even hit 900meg on DB size. Sounds like you need to tidy up your database

[matt40k]

I doubt very much you have a database size in excess of 4GB - we are a large school and dont even hit 900meg on DB size. Sounds like you need to tidy up your database

can't understand either how you could have 4gb or bigger DB. Must be all the nova and old profile rubbish.

>2k students, 240 staff, lesson monitor etc only comes in at around 2GB.

[rasssp]

we are one of the bigger schools. db is currently 3.81gb

2500 students, 350+ staff

[matt40k]

Be tempted to say slap it in RAM

[steve]

1800 students with a 3.5Gb db

Its grown from 2Gb just 18 months ago.

[matt40k]

1800 students with a 3.5Gb db

Its grown from 2Gb just 18 months ago.

What the hell? How? Not something stupid like your sims.ldf being huuge? What modules are you using? Any 3rd party stuff?