26 июня 2012 г. 6:43
I have sql 2008 r2 32bit running on a win2k8 r2 64bit standard OS. The server has 16GB of memory but the 32bit sql (I didn't install it) is only using around 3.7GB. I'm planning to upgrade sql to 64bit soon. The server is only an sql server and nothing else.
Currently the 32bit sql is quite slow. We notice the slowness when using the frontend application when we need to bring up a client list containng 32,000 customers or doing some trivial tasks.
Once I convert the 32bit sql to 64bit, sql will be able to use as much memory I throw at it. From using 3.7GB now to 14GB.
Will I notice a big improvement in speed once I convert it to 64bit?
26 июня 2012 г. 6:59
When running the frontend application and bringing up the client list if you notice on the SQL Server memory pressure then moving to 64 bit should certainly help, however it really depends on where the bottle-neck is, for example if network bandwidth is the issue or the client machine hosting the application then you may not see much difference. Have a look at the following document to try and identify what is causing the slow performance on the server and this should give you a better idea...
/Neil Moorthy - Senior SQL Server DBA/Developer (MCITP (2005/2008), MCAD, ITILv3, OCA 11g) Please click the Mark as Answer button if a post solves your problem
26 июня 2012 г. 8:21ОтвечающийGenerally 64 bits perform better , from my experience.. Just make sure that account ms sql server is running under is added to Locked Page In Memory local policy group.
Best Regards,Uri Dimant SQL Server MVP,http://sqlblog.com/blogs/uri_dimant/