Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: Database: MS SQL Server
 MSSQL Server Indexes
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

Astralis
Senior Member

USA
1218 Posts

Posted - 08 January 2006 :  02:11:07  Show Profile  Send Astralis a Yahoo! Message
Since 2002 my Snitz forum has grown from using an Access DB to a MSSQL Server. When I converted, I tried to maintain the indexes. But, now I do not believe my tables have the proper indexes.

And with all the mods I believe I have made some mistakes. I had my forum turned off as I tracked a memory leak on my site. Today, I turned my forum back on after believing I found it. I then reloaded the active.asp page each minute for six hours (this would still be less than the traffic it receives normally). Then I checked my site's RAM usage and it skyrocketed from 47MB to 77MB!!

So, I need to keep the data but I'm going to do a fresh code install. After I do that, I would like to confirm that my sites' table indexes are formatted properly. Where can I find which indexes to set?

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 08 January 2006 :  06:25:33  Show Profile  Send ruirib a Yahoo! Message
inc_create_forum_mssql.asp has the code to create the tables and the indexes. You can have a look there, even if there are some duplicate indexes and one or two more could be created...


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20595 Posts

Posted - 08 January 2006 :  07:05:58  Show Profile  Visit HuwR's Homepage
quote:
my site's RAM usage and it skyrocketed from 47MB to 77MB!!
an increase of 30Mb is not skyrocketing, that is fairly normal for a large forum, 30Mb of ram is certainly not excessive usage, and indexes are not going to affect the amount of memory your website uses, SQL indexes have nothing to do with IIS, only having a high ADO timeout value will do that.
Go to Top of Page

Astralis
Senior Member

USA
1218 Posts

Posted - 08 January 2006 :  13:52:18  Show Profile  Send Astralis a Yahoo! Message
Thanks! My host thinks anything abover 45MB is intolerable. Unfortunately.

I say it skyrocketed because I've been hovering in the 40s and then with one visitor on my forum hitting it over and over it increased in 30MB which leads me to believe that I didn't close a connection or two or three.

I didn't think the indexes had anything to do with it, but I wasn't sure. But, they're all part of my optimization effort at this point.
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20595 Posts

Posted - 08 January 2006 :  14:36:58  Show Profile  Visit HuwR's Homepage
yes, it does sound like an unclosed connection, also check what your sqlconnection timeout is set to and reduce it wherever possible, this will help to recycle any broken connections.
Go to Top of Page

lduvall
Starting Member

8 Posts

Posted - 17 January 2006 :  08:35:56  Show Profile
quote:
Originally posted by ruirib

inc_create_forum_mssql.asp has the code to create the tables and the indexes. You can have a look there, even if there are some duplicate indexes and one or two more could be created...



I was hoping someone could script out the index Forum_SnitzC58 on the Forum_Members table. I believe my index has become corrupted and I'd like to drop and re-create it. I'm a little baffled as to why I can see the index in Enterprise Manager but not in SQL Query Analyzer. Has anyone else experienced this?
Go to Top of Page

-gary
Development Team Member

406 Posts

Posted - 17 January 2006 :  12:13:05  Show Profile
http://forum.snitz.com/forum/topic.asp?ARCHIVE=true&TOPIC_ID=55051

KawiForums.com


Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.18 seconds. Powered By: Snitz Forums 2000 Version 3.4.07