Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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 (Content by label)
showLabelsfalse
max5
spaces~Glen.Epperson
showSpacefalse
sortmodified
reversetrue
typepage
cqllabel in ("maintenence","mssql") and type = "page" and space = "~Glen.Epperson"
labelsMSSQL Maintenence

Page Properties
hiddentrue


Related issues