SQL permformance

[topher]

Can anyone recommend a tool for alerting/monitor me regarding SQL performance issues and bottlenecks?
thinking of trying Database Performance Analyzer for SQL Server from Solarwinds.

The SQL server isn't memory or CPU bound and the ISCSI disks to the SAN are reporting less than 10 iops..

cheers

 

[topher]

We use Idera Diagnostic Manager at work which shows millisecond delays etc and you can get a free trial. There are also many SQL DMV's that will show you disk performance which google will help you find. 10 iops is a serious issue and I'd ask your networking/SAN guys for assistance asap. You can also run the Microsoft SQL stress testing tool which simulates disk activity https://support.microsoft.com/en-us/kb/231619
Good luck.

I mean the database is only using 10 iops.. the SAN is running fine