Update DB Statistics

Owned by Glen Epperson (Unlicensed)
Last updated: Nov 03, 2017 by Conor McCann

Symptom

Standard queries and reports run very slowly or fail to complete.

Problem

The database server statistics are out of date or incomplete.  

Solution

Connect to the iQSonar database as an administrator user (typically username ‘sa’). Issue the command

EXEC sp_updatestats

Filter by label

There are no items with the selected labels at this time.

 

Â