[SIMS] Optimising Edit Marks (Lesson Monitor)

[jinnantonnixx]

For SIMS?

I lied. Only 97 for SIMS. I counted test databases too. But seriously, yes all running happily on one server. It's a bit of a beast, mind you.

3> select count(*) from sys.databases where name like 'SIMS%'
4> go

-----------
97

(1 row affected)

[jinnantonnixx]

Unfortunately we were told by the CC that it can't be 64 bit. The database was just migrated onto the (32 bit) VM at the highest specced OS, which was 2008 SP2 Enterprise.

Not 64 bit? Why on earth not?

[Gongalong]

It's a bit of a beast, mind you.

It must be!

Not 64 bit? Why on earth not?

No idea. Part of the pre-requisites

[3s-gtech]

2008 R2 has been supported for a good while now, I can't believe they insisted on a 32 bit OS. I'm sure many on here are running it on 64 bit host, with good reason!

[jinnantonnixx]

2008 R2 has been supported for a good while now, I can't believe they insisted on a 32 bit OS. I'm sure many on here are running it on 64 bit host, with good reason!

Absolutely. Unless it's a licensing issue, and times are hard, there's no reason to NOT be on 64 bit, for both OS & SQL.

[matt40k]

Only thing I can think of, other then licensing, is they've got muddlied up about the fms workstation recommendation - ie don't mix. Servers don't count as you don't work on them. 64bit should be standard now.

I know @Polski been doing a fair bit of work on getting the best out of 32bit sql server (licensing issue among other practial problems why the servers stuck on 32bit.)

[vikpaw]

It's probably because either the cc don't run 64 bit yet, or just think it will be an extra factor for them to support, that they don't want to bother with.

[matt40k]

I've heard some LA buy secondaries the SQL licenses, could be they didn't get software assurance.

[Gongalong]

Yep, we didn't install SQL, the LA did. We have a Datacenter license(s), but I don't know whether that includes SQL Server.

I'm frustrated that we didn't get the best OS for the job, as I don't want to have migrate SIMS again!