ITPOL
asked on
How does MS SQL use the hardware it's running on?
I'm looking at buying a new software package for our company and I need to spec a suitable server for it.
The software uses MS SQL server to store the data. They haven't (so far) been able to provide me with info I can use to size suitable server hardware.
The company say it can run on SQL express or the bigger versions. I see that the non-express versions of SQL can use multiple CPU sockets and more than 1GB RAM.
Does the product/database have to be developed in such as way as to take advantage of the extra hardware? Or does SQL server automatically do this for you? (and therefore give you much better performance?)
If it's relevant; the software's data is not all in one big database, but is split into one database per client (of ours).
Many Thanks
The software uses MS SQL server to store the data. They haven't (so far) been able to provide me with info I can use to size suitable server hardware.
The company say it can run on SQL express or the bigger versions. I see that the non-express versions of SQL can use multiple CPU sockets and more than 1GB RAM.
Does the product/database have to be developed in such as way as to take advantage of the extra hardware? Or does SQL server automatically do this for you? (and therefore give you much better performance?)
If it's relevant; the software's data is not all in one big database, but is split into one database per client (of ours).
Many Thanks
SQL server will use what resources it needs when it comes to CPU and RAM. If it is a critical system then stay away from Express Edition due to its limitations. Also keep in mind as to how many users you have as it will affect licensing (core vs user). It is also recommended to install in a virtualized environment to reduce cost.
By default SQL Server will use all available resources (CPU & RAM). This values can be configured manually to fit your needs.
Since SQL Server 2008R2 Express Edition that database limit is 10GB, so you may check if this is enough for your solution.
Since SQL Server 2008R2 Express Edition that database limit is 10GB, so you may check if this is enough for your solution.
ASKER
thanks,
OK just so I'm 100% clear;
Theoretically speaking, and using exactly the same databases;
If I get a 2-socket server with say 16Gb RAM and SQL Standard
versus
a 1-socket server (using same CPU), 16Gb RAM and SQL Express;
I WILL see better performance? Regardless of the application or database design?
OK just so I'm 100% clear;
Theoretically speaking, and using exactly the same databases;
If I get a 2-socket server with say 16Gb RAM and SQL Standard
versus
a 1-socket server (using same CPU), 16Gb RAM and SQL Express;
I WILL see better performance? Regardless of the application or database design?
No, you wont.
You can use only 1 socket of 4 cores and 1GB RAM for Express Edition.
You can use only 1 socket of 4 cores and 1GB RAM for Express Edition.
ASKER
Hi Vitor,
Sorry that's my point. Given that the full version of SQL server can use the additional hardware, does it guarantee me better performance of the same application and databases?
You can use only 1 socket of 4 cores and 1GB RAM for Express Edition.
Sorry that's my point. Given that the full version of SQL server can use the additional hardware, does it guarantee me better performance of the same application and databases?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
excellent thankyou