Background

Recently we ran into a performance issue and wanted to compare our in-house environment against the Vendor’s Original implementation environment.

Is it Storage?

From what we observed our query was eating up a lot of tempdb storage and so quickly zeroed in how tempdb is configured.

Does the number of tempdb files match the number of processor cores
Are the tempdb files sized equally and do they have the same growth pattern
Is Instant File Initialization ( IFI ) enabled for the service account that SQL is running under

The other concern is whether our hardware has the neccesary IOPS

And, so bring ups the question what type of storage do we have?

Is it Local Disk
- Mechanic rotating disk
- SSD
Is it Network Storage
- Are we running SAN
- Do we have sufficient memory ( PAM )

Wanted to document the steps that needs to be taken by the vendor to document their storage.

And, so tried to try things out on my laptop as I prepared those steps.

Ran “Device Manager”

NVMe CX2-8B256-Q11 NV SCSI Disk Device

The Device name “NVMe CX2-8B256-Q11 NV SCSI Disk Device” does not tell me whether it is an SSD Drive or not.

Let us google on the device name and we found matches

From Google we can see that the top matches suggests that we have an SSD Drive.

The computer is a Dell, let us go to it’s support site and see if it helps us identify the Storage type.

Dell Support is available here.

Launched Internet Explorer
Enter the URL for Dell Support
On Dell’s Support Site
- Installed Dell System Detect
- Dell’s tool detected that our system is Latitude E7270
- Once our computer is detected access the “System configuration” Tab
- The Part number is “SSDR, 256G, P34, 80S3, SAMSUNG, PM951“