Home > Storage > PowerStore > Databases and Data Analytics > Dell PowerStore: Microsoft SQL Server Best Practices > Overview
Storage performance is critical for SQL Server workloads. PowerStore makes it simple and intuitive to observe and manage storage performance. Performance metrics and graphs are available in the PowerStore dashboard and for almost every data path component available in PowerStore manager.
Performance graphs for monitoring metrics such as latency, IOPS, bandwidth, and I/O size are available in the PowerStore Manager. These performance charts can be printed and exported into various formats. Note that when viewing PowerStore performance charts, the granularity on PowerStore I/O size is 1K and I/O size is rounded up to the nearest 1K. Because SQL Server can produce I/O smaller than 1K, this may appear as a discrepancy, but smaller sizes are rounded up to 1K in the performance chart. In these cases, IOPS and bandwidth can be used to calculate a more exact I/O size (I/O size = bandwidth/IOPS).
The following sections explain key features that are useful for observing and managing SQL Server storage performance.