...
Reference Values (in %) | Action | SQL statement |
avg_fragmentation_in_percent > 5 AND < 30 | Reorganize Index | ALTER INDEX REORGANIZE |
avg_fragmentation_in_percent > 30 | Rebuild Index | ALTER INDEX REBUILD |
...
SQL logs
SQL server log files are found in the Management section of the Object Browser of SQL.
...
You need to be a member of the security admin role in order to access these logs.
...
...
Table growth
More will be provide on table growth in version two. Basically key tables should be monitored for growth so that database/disk sizing can be predicted. It can also lead to decisions on purging.
A plan to compare key table growth from week to week or month to month might provide good information.
...
SQL Profiler
SQL Server Profiler is a graphical tool that allows you to monitor and collect server events such as:
...
SQL Profiler is useful for troubleshooting spLocal_* stored procedures created specifically for sites.
Allows you to see the values of the input parameters
Allows the capture of run statistics.
Open an existing trace or create a new one.
Save to a file.
Add filters to make traces more efficient and easier to read.
Most useful filters are:
LoginName=comxclient
TextData Like %splocal%
ApplicationName Like Proficy%
...
spSupport_Blocking
Plant Applications is installed with a Stored procedure that will determine whether there is Blocking occurring in the database. There may be a need to have heightened permissions to execute this. Below is an example of running it and observing that there are no blocks.
...