I am an Lan admin, in a bind on this Saturday..I'm going independant, but
fairly green with MS Sql. But I can muddle around as needed though. Here's my
problem and proposed solution. Can someone verify this? Thanks in advance!
I have a client, running MS SQL ver 2000 RTM ver. Yes no sp apparently. I
didn't set it up, he's just a new client of mine and I'm trying to advise/
fix things for him.
O/s: Win 2k server. not sure what sp.
Storage: Old 35 GB hd. Partitioned C: at 4gb, (yes 4) second partition about
30gb, as data area E drive.
The tempdbs are on C: and get up to 2 gb causing problems. C: partition is
chocked full
1. Should I move the tempdbs, log etc to E: data partition? I know it should
stay away from data area and I should get a new HD for him so this would be
temporary. I researched the code on how to move the log dbs. Seems easy enuf.
2. Any reason not to install the service packs? slammer comes to mind.
3. Should the xaction logging on the tempdb be changed? Its default and
unlimited growth, at 10%
You also use my email address for replies.. tfconsulting@.gmail.com
Much appreciated
Thanks;
TF1. Yes, do this. storing this on the system database can be really
critical for performance:
http://support.microsoft.com/kb/187824/en-us
2. No, if there are no implications from your software vendors which
are using the db, install the service packs as they will provide you
more stability within the system and more free time not concerning
about problems which could be fixed using the right service pack level.
3, You shoudl provide enough space not to extend and shrink the db,
which can be very costly (on a performance basis) and use the extend
option to provide more possibilities to grow.
HTH, jens Suessmeyer.
No comments:
Post a Comment