Database read/write

contracer

Is there any command to see how much miliseconds are NPM spending to read/write a

data in the database ?

mark_wiggans

To ensure your SQL Server resources can keep up with polled data insertions:

1. Log on to the database server with an administrator account.
2. Click Start > Run.
3. Type perfmon in the Run dialog, and then click OK.
4. Click Avg Disk Queue Length in the table below the graph.
5. Ensure the Average value is less than twice the number of physical hard drives in your SQL Server.