Re: max number of databases

From: NAN (anonymous_at_discussions.microsoft.com)
Date: 08/17/04 

Date: Tue, 17 Aug 2004 11:20:48 -0700

>-----Original Message-----
>You should probably see what is being written to it and
address that issue
>before anything else. If it's too large then look at it
as soon as you
>reset it.
>
>--
>Andrew J. Kelly SQL MVP
>
>
>"NAN" <anonymous@discussions.microsoft.com> wrote in
message
>news:4ef701c48066$09a0d010$a601280a@phx.gbl...
>>
>> >-----Original Message-----
>> >Hi,
>> >
>> >Adding new databases to the server may not be a issue.
>> Could you check your
>> >CPU - Processor time
>> >and Memory usage (Available bytes MB) during peak time.
>> If your available
>> >memory and CPU hits are
>> >normal then you can create more databases, Because SQL
>> server will take very
>> >less memory to open a database.
>> >
>> >Thanks
>> >Hari
>> >MCDBA
>> >
>> >"NAN" <anonymous@discussions.microsoft.com> wrote in
>> message
>> >news:48de01c47ff2$7f980960$a401280a@phx.gbl...
>> >> I realize it all has to do with how much ram, disk
>> space,
>> >> cpu, etc.. but is there a maximum number of databases
>> you
>> >> should have on 1 database server? Here are some
specs:
>> >> 2cpu's @1ghz
>> >> 2 gb ram
>> >> plenty of disk space
>> >> clustered
>> >> The problem is that mgmt keeps putting more and more
>> db's
>> >> on this server (there are over 60). Every day the
error
>> >> log has to be deleted because it is too large to
open.
>> >> Mgmt now wants reasons why NOT to put any more db's
on
>> >> this server. They are koo koo.
>> >> Thanks.
>> >
>> >
>> >.
>> >Will do. What about not being able to open the sql
error
>> log? Any idea how to fix that?
>> Thanks.
>
>
>.
>For every person who logs into the db, it creates an
entry in the log file. Our Db admin says there are alot
of these. Any way to not log these?
Thanks.

Relevant Pages

  • Re: [OpenVMS Alpha V7.3-2] Batch/Print Job Numbering
    ... $ SUBMIT/qualifierfilespec/HOLD ... listing of every entry number used for that job in ascending order by ... Imagine his queue numbers run from 1 to 1000. ... ...is output to the log file, that will help naarow it down, but not ...
    (comp.os.vms)
  • Re: Help - (getting intermittent 404s)- This sites my last hope!
    ... The entry below that looks funny, ... However, as Robear mentioned, you really need to post your HJT log file to one of the forums he mentioned to have a real expert interpret it. ... You said that tool can help me to fix things but I need to know really, ... I end up with a damaged IP stack (Dont think its the browser itself as Opera ...
    (microsoft.public.windows.inetexplorer.ie6.browser)
  • Re: [OpenVMS Alpha V7.3-2] Batch/Print Job Numbering
    ... to find out why entry x failed. ... Sorry, didn't have a queue entry handy to use as an example, but that's ... ....is output to the log file, that will help naarow it down, but not ... Unofficial OpenVMS Hobbyist Support Page: ...
    (comp.os.vms)
  • Re: Permissions on Event Log?
    ... If I create a custom log file and fill the entire hard drive that effects ... Adding an event source affects the whole system and not that single user - ... You could have an admin install, but then the user may need to log off ...
    (microsoft.public.dotnet.security)
  • Re: [OpenVMS Alpha V7.3-2] Batch/Print Job Numbering
    ... $ SUBMIT/qualifierfilespec/HOLD ... listing of every entry number used for that job in ascending order by ... Imagine his queue numbers run from 1 to 1000. ... ...is output to the log file, that will help naarow it down, but not ...
    (comp.os.vms)