How to Identify if SQL Server is 32-bit or 64-bit

[Katha]

Issue

A malfunction in Power Monitoring Expert (PME) may occur due to the installation of a 32-bit version of SQL Server.

Product Line

EcoStruxure Building Operation

Environment

Power Monitoring Expert

Cause

The issue may stem from using a 32-bit SQL Server, which is incompatible or suboptimal for PME.

Resolution

You can determine the SQL Server architecture using either of the following methods:

---

Method 1: Using SERVERPROPERTY

1. Open SQL Server Management Studio (SSMS) and connect to the target SQL Server instance.
2. Click New Query.
3. Ensure the master database is selected.
4. Run the following query:

   SELECT CASE
            WHEN CHARINDEX('64', CAST(SERVERPROPERTY('Edition') AS VARCHAR(100))) > 0 
            THEN 64 
            ELSE 32 
          END AS [SQL Server Bit Version];

5. Click Execute.

🔍 Result: The query returns either 32 or 64, indicating the bit version of the SQL Server instance.

---

Method 2: Using @@VERSION

Alternatively, run the following query:

SELECT @@VERSION;

🔍 Example Output:

Microsoft SQL Server 2008 R2 (SP1) - 10.50.2550.0 (X64)
Standard Edition (64-bit) on Windows NT 6.1 (Build 7601: Service Pack 1)

Look for (X64) or (32-bit) in the output to determine the architecture.