| Author |
 Topic  |
|
|
chp
Starting Member
16 Posts |
 Posted - 20 December 2008 : 13:37:33
|
Hi,
My Forum database was recently moved from another box to my own dedicated server (saga here). I was not able to connect to the new database, and we determined that it was a permissions issue. HuwR gave me a fix to work around some funky permissions issues, basically involving modifying the strTablePrefix_ variable to include the table owner's name beforehand ([dbo].strTablePrefix_).
Now that I can connect to the database, I'm seeing something else: Disk queue length spikes to 100% the minute I connect to the local database, and I get more SQL timeout errors than ever before -- sometimes three in a row before any page in my forum will display.
I'm not familiar with what the disk queue length signifies, but it is something that a RAM/ROM upgrade would fix? Or is there another way to figure out what could be happening and how it could be fixed?
I greatly appreciate any thoughts you may have on this.< |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 20 December 2008 : 16:24:29
|
| Either you are on a hugely underpowered server, or you have a huge amount of traffic (maybe both?) or your database was not properly transferred. Can you check whether you have indexes on your database?< |
Snitz 3.4 Readme | Like the support? Support Snitz too |
 |
|
|
chp
Starting Member
16 Posts |
Posted - 20 December 2008 : 23:03:23
|
Hello Rui! I'm going to ask you a very stupid question and I apologize right now: How can I check to see if I have indexes on my database?
(Clara skulks off to await the laughter...)< |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 21 December 2008 : 04:39:26
|
| In enterprise manager, expand your table list, then right click on say the forum_topics table and select 'manage indexes' from the popup menu, if anything is listed in the window that appears then you should be ok, if the window is empty then you will need to create the indexes.< |
|
|
|
Etymon
Advanced Member
United States
2385 Posts |
Posted - 21 December 2008 : 07:58:51
|
In the Microsoft SQL Server 2005 Express Edition (aka SQL Server Express) the Indexes are found in the list of folders below FORUM_TOPICS. Double click on FORUM_TOPICS or just click on the + sign to look for Indexes and then either double click on Indexes or click on its + sign.
If the Indexes folder expands down and shows you a list of entries, then those entries are what Rui and Huw are hoping you will see.< |
Edited by - Etymon on 21 December 2008 07:59:34 |
|
|
|
chp
Starting Member
16 Posts |
Posted - 21 December 2008 : 17:12:13
|
Thank you!
I'm running SQL Server 2000. When I check the "manage indexes" option on, say, the forum_members table, I do see two indexes. They are not clustered. Most of the tables do have indexes, and some (forum_topics) have more (forum_topics has 7 indexes). Would I be better of re-creating the indexes perhaps?< |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
chp
Starting Member
16 Posts |
Posted - 21 December 2008 : 18:10:39
|
| Gotcha. I'll do that. Thank you!< |
|
|
| |
Topic |
|
Topic Locked
