Been lurking in the forum all morning soaking up as much information I can on migrating the native database to SQL server as possible.
Is there some document, or some resource that can provide me a detailed explanation of the process?
While there are several advantages, our main reason for moving to SQL Server is that we feel we'll solve a plaguing performance issue that we currently have with the native database. We feel that the combination of the Hardware we're using, coupled with SQL's ability to use it will be the solution we've long been looking for ... [-o<
What happens is that our disk queue length shoots up to 100% for long periods of time, and the users experience slow periods of system access...
Database is 25gig, here are approx. 40 concurrent users accessing it
Server is a Gen3 dual Xeon 2.0 DL380, 4 gig ram, 15k SCSI Raid 1 ( 2 disks)
I've also tried on a BL20p Dual 3.2Ghz Xeon, 2 gig of RAM, connected to a Raid 1 SAN w/ 10,000 RPM SATA drives.......it was even slower, but even if you have 1 user in i, the disk qeue shoots up to the top...
I'll be trying a new DL380 Gen4 Dual Xeon with 4 (Raid 1+0) 15k SCSI drives and 6 gig of RAM and we'll see what happens in Native, but we think SQL Server will perform better...