June 11, 2007 at 2:45 pm
Is there a quick and easy way to figure out if a server is 64 bit or 32 bit? I have been looking and cannot figure out an easy way. If there is a script that will figure it out could you please tell me. I am a DBA and manage over 100 servers and need a fast and easy way to figure this out.
-Kyle
June 11, 2007 at 3:02 pm
Could allways parse out the @@version information, right after the version number it will list the architecture it is for (like on mine says Intel X86).
June 12, 2007 at 12:15 pm
So this bugged me, had to be a better way.
exec
master.dbo.xp_msver
Index = 4 is for the platform, in mine says NT Intel X86. I don't have a 64 bit server up and running SQL on it, so can't verify what this would say if on a 64 bit. Anyone?
June 13, 2007 at 2:53 am
Look in the system Environment variable PROCESSOR_ARCHITECTURE.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
June 13, 2007 at 2:57 am
Maybe this can help:
June 13, 2007 at 7:29 am
The stored pocedure gives all the info you may need. I assume you would be interested that SQL Server is 64 bit if running on x64 bit platform. Someone could run 32 bit on x64 bit OS.
GE
1 ProductName NULL Microsoft SQL Server
2 ProductVersion 589824 9.00.2153.00
3 Language 1033 English (United States)
4 Platform NULL NT AMD64
5 Comments NULL NT AMD64
6 CompanyName NULL Microsoft Corporation
7 FileDescription NULL SQL Server Windows NT - 64 Bit
8 FileVersion NULL 2005.090.2153.00
June 13, 2007 at 7:32 am
Thanks you for all your help. My issue has been resolved.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply