MSSQL database performance increase
Hi,
I was doing some testing regarding performance
and did a query to get non index and index fragmentation
Best regards,
I was doing some testing regarding performance
and did a query to get non index and index fragmentation
That in some tables was over 90%
So I manually rebuilt the indexes on a test database and notices some performance gain
So I got really curios and stopped the service backed up the ServiceDesk database and ran this sql query in MS sql Management Console
and started the service again after it had finished
I haven´t done any calculations but I think this is well over 30% performance gain for SDP
I also tested with OpManager and that feels like over 50% performance gain for a OpManager System that has been running over 5 year
Maybe you can test this and hopefully if this gets your stamp of approval
this might be useful for you customers :)
this might be useful for you customers :)
USE ServiceDesk --The name of the service desk Database
DECLARE @TableName varchar(255)
DECLARE TableCursor CURSOR FOR
SELECT table_name FROM information_schema.tables
WHERE table_type = 'base table'
OPEN TableCursor
FETCH NEXT FROM TableCursor INTO @TableName
WHILE @@FETCH_STATUS = 0
BEGIN
DBCC DBREINDEX(@TableName,' ',90)
FETCH NEXT FROM TableCursor INTO @TableName
END
CLOSE TableCursor
DEALLOCATE TableCursor
Best regards,
Valdi Hafdal
URL :
http://www.vlink.is
V-Support for Support Center Plus
V-Technician for Service Desk Plus