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
- 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
What type of Storage
And, so bring ups the question what type of storage do we have?
- Is it Local Disk
- Mechanic rotating disk
- 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“
Do you want to install this application?
Accept Terms and Conditions
Support for Latitude E7270
From Dell’s support site, we detected that our storage is :
SSDR, 256G, P34, 80S3, SAMSUNG, PM951
Vendor :- Samsung
Size :- 256 GB