| Author |
 Topic  |
|
|
Addicted2HD
Starting Member
21 Posts |
 Posted - 27 July 2007 : 15:58:12
|
Hi,
Just wondering if I should be managing my database other than increasing it's size as needed. Right now it's up to about 120mb. Running a shrink command on the database only shrinks the file size by about 2-4 mb.
Sorry, should have mentioned that it's running on MS SQL Server 2005, recently migrated, was previously on MS SQL Server 2000.
TIA,
Scott |
Edited by - Addicted2HD on 27 July 2007 15:59:14 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 27 July 2007 : 16:05:10
|
Other than that, an occasional index rebuild may be needed, but a performance degradation may make that need clear.
If you're the cautious kind, you may also want to perform an occasional backup for a local Db, if you choose not to rely solely on the host. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
 |
|
|
Addicted2HD
Starting Member
21 Posts |
Posted - 29 July 2007 : 09:30:49
|
ruirib,
Thanks for the response. I do a manual backup weekly and being on a dedicated server we have nightly backups as well. I'll check into the index rebuild. The only performance that is hit and miss at time is the search times out on occasion, but not as often as it did on the shared server we used to have the site hosted on.
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
pdrg
Support Moderator
United Kingdom
2897 Posts |
Posted - 29 July 2007 : 10:29:18
|
Yep - when you do your backups, do you do them through the MSSQL 'backup' interface? I'd be wondering if you've got a huge Transaction Log which should empty itself somewhat on a full backup, but maybe you're hitting problems, or could look to truncating your TLog if things are quiet one night and it was safe to do so (ie all transactions safely committed). Sometimes, outstanding transactions can leave you with TLog bloat.
How big is the .mdf file and how big is the .ldf file? Is the db just powering a snitz forum, or is there other stuff/development/etc on there? |
|
|
|
Addicted2HD
Starting Member
21 Posts |
Posted - 14 August 2007 : 09:57:12
|
Looks like I'm going to need to install that modified version of search.asp. Can you point me to it? I spent a little time looking for it and didn't find any link to it in the forums.
Thanks. |
|
|
|
Podge
Support Moderator
Ireland
3776 Posts |
|
|
Addicted2HD
Starting Member
21 Posts |
Posted - 14 August 2007 : 10:31:45
|
Thanks for the link.
No timeouts on any other pages, just the search. |
|
|
|
Addicted2HD
Starting Member
21 Posts |
Posted - 14 August 2007 : 10:39:42
|
I just tried to download Gary's modified version and get a message that the system cannot find the file on his server. Is there an updated link that I missed? I downloaded the original mod and the search is working better now. Gary's is supposed to be faster so I thought I'd give that a try also.
Thanks. |
|
|
|
Chris.Shaw
Starting Member
1 Posts |
Posted - 26 November 2007 : 19:31:17
|
Addicted2HD,
There are many things that you should be looking for when you monitor your SQL Server. I noticed your post when I was looking for some information for a client of mine that is running SNITZ. Not only do you have to worry about backups and performance but errors, job maintenance, and growth forecast. If you would like to chat about this more feel free to e-mail me at Chris.Shaw@SQLonCall.com |
|
|
|
Etymon
Advanced Member
United States
2396 Posts |
Posted - 27 November 2007 : 01:31:47
|
quote:
Originally posted by Addicted2HD
I just tried to download Gary's modified version and get a message that the system cannot find the file on his server. Is there an updated link that I missed? I downloaded the original mod and the search is working better now. Gary's is supposed to be faster so I thought I'd give that a try also.
Thanks.
Gary recently created a project for his search code at GoogleCode here:
Project here: http://snitzsqlftsearch.googlecode.com
Source here: http://snitzsqlftsearch.googlecode.com/svn/trunk/
|
|
|
| |
Topic |
|
Topic Locked
