Printer Friendly Version
Email this thread to a friend
|
Featured Web Site Template |
|
Reflects user activity within the last 5 minutes
|
|
| Member |
Message |
unreviewed
Joined: Dec 07, 2000
# Posts: 6776
|
Posted: 2004-Apr-16 07:21
Need to talk to someone experienced with optimising the balance between memory and database size and of course what I'm doing with that database.
SQL Version 2000 Enterprise.
Help me, I'm melting ...
|
 |
NEntropy
Joined: Dec 08, 1999
# Posts: 1117
|
Posted: 2004-Apr-17 03:18
There isn't one simple way to optimize databases. You need understanding of the structure of your database, as well as how it's laid out, what kind of platform it runs on, how much load is placed on it, and many other factors. This is one of those cases where hiring a database administrator (DBA) would be the most appropriate action.
Simply put, though, more memory is good. Your memory size should be such that at least all of the indicies of the database could stay loaded in memory.
|
|
You are not permitted to post messages in this forum or topic, because of one or more of the following reasons:
- You have not yet logged in, or registered properly as a member
- You are a member, but no longer have posting rights.
- This is a private forum, for which you do not have permissions.
If you are a recent member, it's possible that you simply have not yet confirmed your account. Please
check your email for a message entitled 'JimWorld Forums: Confirm Your Account' and follow the instructions
contained within.
If you cannot find this message, click here to Re-Send it.
|
If you are still experiencing problem, please read the
Login Assistance
Article for some advice on what may be causing your login not to work properly.
|
Switch to Advanced Editor and ...
Create a New Topic
or Reply to this Thread
|
|
Inbox
