SQL Express performance on XP
-
Hi all, I have questions on SQL Express 2005 performance. Will it be faster if it is installed on Windows Server compared to on Windows XP? (I guess whatever the answer to this will apply to SQL 2005 (non-Express) as well). The other question (since I am not IT guy): what exactly are different in Server hardware compared to Client hardware? (Usually they are much more expensive). Will the performance of Windows Server (and all its programs) suffer if it is installed on a client-spec hardware? Thanks for any input.
-
Hi all, I have questions on SQL Express 2005 performance. Will it be faster if it is installed on Windows Server compared to on Windows XP? (I guess whatever the answer to this will apply to SQL 2005 (non-Express) as well). The other question (since I am not IT guy): what exactly are different in Server hardware compared to Client hardware? (Usually they are much more expensive). Will the performance of Windows Server (and all its programs) suffer if it is installed on a client-spec hardware? Thanks for any input.
I think the bigger issue with performance is hardware. If you have a single CPU system it is not going to be very good either way. If you have a multiple cpu system that is better. sql express 2005 is limited to the amount of ram and cpus it can use. The regular version is not. It is also limited to the size of the database. So if you want you database to be fast, have multiple CPU's lots of Ram and fast hard drives. It also can help to have your database and log files on different volumns (multiple hard drives). Here's a link on sql express 2005 limitations http://searchsqlserver.techtarget.com/tip/1,289483,sid87_gci1082707,00.html[^] Hope that helps. Ben
-
I think the bigger issue with performance is hardware. If you have a single CPU system it is not going to be very good either way. If you have a multiple cpu system that is better. sql express 2005 is limited to the amount of ram and cpus it can use. The regular version is not. It is also limited to the size of the database. So if you want you database to be fast, have multiple CPU's lots of Ram and fast hard drives. It also can help to have your database and log files on different volumns (multiple hard drives). Here's a link on sql express 2005 limitations http://searchsqlserver.techtarget.com/tip/1,289483,sid87_gci1082707,00.html[^] Hope that helps. Ben
Are you saying that the performance of SQL Express on Windows XP will be the same with performance of full SQL Server on Windows Server 2003 if both of these are using the same machine (1 CPU, 1GB RAM) serving lets say, 5 clients? (I know that full version is the logical choice for serving large number of clients). Thanks.
-
Are you saying that the performance of SQL Express on Windows XP will be the same with performance of full SQL Server on Windows Server 2003 if both of these are using the same machine (1 CPU, 1GB RAM) serving lets say, 5 clients? (I know that full version is the logical choice for serving large number of clients). Thanks.
Yes, according to their own details, it is the same thing just a smaller limited version. If you only have 5 clients and their databases will be under the limit then it sure is a lot cheaper. Actually if you decided to install the Sql express locally on the PC that the application was running on sql express would be faster then the full version since it wouldn't have to go across the network. Ben