Author |
Topic  |
|
Astralis
Senior Member
   
USA
1218 Posts |
Posted - 08 January 2006 : 02:11:07
|
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
|
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 |
 |
|
HuwR
Forum Admin
    
United Kingdom
20595 Posts |
Posted - 08 January 2006 : 07:05:58
|
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. |
 |
|
Astralis
Senior Member
   
USA
1218 Posts |
Posted - 08 January 2006 : 13:52:18
|
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. |
 |
|
HuwR
Forum Admin
    
United Kingdom
20595 Posts |
Posted - 08 January 2006 : 14:36:58
|
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. |
 |
|
lduvall
Starting Member
8 Posts |
Posted - 17 January 2006 : 08:35:56
|
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? |
 |
|
-gary
Development Team Member
 
406 Posts |
|
|
Topic  |
|