Web Wiz Forums - SQL server optimization tool for v10?

Print Page | Close Window

SQL server optimization tool for v10?

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=29522
Printed Date: 01 April 2026 at 8:47am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: SQL server optimization tool for v10?

Posted By: iSec
Subject: SQL server optimization tool for v10?
Date Posted: 10 July 2011 at 4:02pm

Is there a database optimization tool for WWF v10 like there is for v9?

-------------
"When it gets dark enough, you can see the stars"
-Charles A. Beard

Replies:

Posted By: Nick-V
Date Posted: 10 July 2011 at 7:53pm

For various databases including WWF I use a free utility called http://expressmaint.codeplex.com/" rel="nofollow - expressmaint.sql which is installed in MASTER.

I call this utility manually once in a while using the following stored procedure:

USE [wwf]
GO
/****** Object: StoredProcedure [dbo].[iReindex] Script Date: 07/10/2011 19:52:36 ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
ALTER PROCEDURE [dbo].[iReindex] AS

exec master.dbo.expressmaint
@database = 'wwf',
@optype = 'REINDEX',
@report = 0

dbcc shrinkdatabase(wwf, truncateonly)

exec sp_updatestats