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.

Configuration of Tempdb

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

 

Hardware Itself

The other concern is whether our hardware has the neccesary IOPS

What type of Storage

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

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

 

Self

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.

 

Device Manager

Ran “Device Manager”

Image

Textual

NVMe CX2-8B256-Q11 NV SCSI Disk Device

 

Explanation

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

 

Google

Let us google on the device name and we found matches

Image

Textual

1. CX2 NVMe Series – Liteon SSD
   Link
2. LITEONIT Solid State Drive Firmware Driver Details | Dell US
   Link

 

Explanation

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

 

Dell

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.

Steps

1. Launched Internet Explorer
2. Enter the URL for Dell Support
3. 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“

Image

Do you want to install this application?

Accept Terms and Conditions

Installation

Support for Latitude E7270

 

Part Number

 

Summary

From Dell’s support site, we detected that our storage is :

SSDR, 256G, P34, 80S3, SAMSUNG, PM951

Vendor :- Samsung
Size :- 256 GB