Re: Autoshrink and Autogrow

From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 09/29/04 

Date: Wed, 29 Sep 2004 19:00:41 +0200

Here's some ammunition:
http://www.karaszi.com/SQLServer/info_dont_shrink.asp 

-- 
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Art" <anonymous@discussions.microsoft.com> wrote in message 
news:008f01c4a63b$41f93970$a301280a@phx.gbl...
> Space.  They wouldn't get me more space so I kept having
> drives filling up.  I finally talked them into getting me
> more space on one of the servers and just did a
> migration.  I of course am about take all the autoshrinks
> off on that server.
>
> But on the other server where I am still struggling with
> space issues, I am looking for "fuel" to get them to get
> me more space.  That's part of why I'd like to monitor the
> server and show them the effect (besides fragmentation of
> course) that this is having on the server.
>
> How can I show them that?
>
>>-----Original Message-----
>>Why on earth do you have autoshrink enabled?
>>
>>-- 
>>http://www.aspfaq.com/
>>(Reverse address to reply.)
>>
>>
>>
>>> 1. How can I monitor autogrow and autoshrink?
>>> 2. How can I tell how much cpu and disk they're using?
>>> 3. What is an acceptable threshold for context switching
>>> for a four cpu server?
>>
>>
>>.
>>

Relevant Pages

  • Re: SQL7 DB - 100% CPU Last / Einfrieren des Servers
    ... > seit einiger Zeit habe ich auf einen Produktiv Server ... > das Problem das der Server immer für ein paar Sekunden ... Dazu müsstest Du mal versuchen die Operationen zu ermitteln ... Considerations for Autogrow and Autoshrink Configuration ...
    (microsoft.public.de.sqlserver)
  • Re: Autoshrink and Autogrow
    ... off on that server. ... How can I monitor autogrow and autoshrink? ... >> for a four cpu server? ...
    (microsoft.public.sqlserver.server)
  • Re: [9fans] Hopefully, one last problem
    ... I have run auth/changeuser bootes and auth/changeuser kim ... The auth server logs to /sys/log/auth. ... On the cpu server, run auth/debug. ... Drawterm is printing the message "server lies". ...
    (comp.os.plan9)
  • [9fans] Issues with 2 networks, fs server, and namespaces
    ... ESXi, and working great -- CPU server running with two APs, though ... Both Auth and CPU are on the public ... While I've configured the internal network to be on it's own ...
    (comp.os.plan9)
  • Re: [9fans] Adventures of a home user
    ... acquainted with the Plan 9 environment, ... One way it can be useful is as a replacement for drawterm. ... and the auth server IP addresses and then I get the same ... my terminal or I can cpu into the cpu server. ...
    (comp.os.plan9)
Loading