[dba-SQLServer] DB growth spurt/Comparison tool

[fhtapia at gmail.com]

so if you are backing up with a transaction log, you can save the backup
and the log, then recover to a new database, and compare the old an new
database using either RedGate's Schema's compare or their DataCompare tool,
they give you a 14 day trial so you can look around and validate what
changed.

read the section under: Errors and Warnings for this article:
https://www.simple-talk.com/sql/performance/the-default-trace-in-sql-server---the-power-of-performance-and-security-auditing/
i get that you are running out of memory, but you may want to review your
execution plans and validate that the data you are selecting is appropriate
for the end user.  you might need to add additional criteria to select less
content when appropriate.

Regards,
Francisco

On Fri, Apr 8, 2016 at 6:28 PM J- P <jnatola at hotmail.com> wrote:

> Hi all,
> Warning , this is a longer  than usual , bit elaborate thread.
>
> Environment;
>
> sql express 2005 database (2000 compatibility mode) on 2003 server;
>  Access  front end;
> ~40 users;
> DB size 1.6 GB
>
> Scenario;
> Front end starts hanging on certain menus (spinning wheel of death the
> users call it)
> Sometimes it comes back on its own , sometimes they restart the sql service
> (with my limited knowledge i ran profiler and have found every time it
> freezes/crashes the trace shows "sort warnings with event subclass 1 pass)
> I know add more memory is the band-aid , however , express is limited to
> 1GB and I believe it's a problem pertaining to queries )
>
> Now I have been telling the owner for years he needs to to get current,
> get a real DBA and clean things up (another story completely )
>
> Today the "DBM (database maintainer I call him, because he is by NO MEANS
> a DBA) did something trying to "fix the issue"
> and the database became pretty much unusable- sort warning up the  wazoo.
>
> I looked at the backups and the database went from 1.6GB to 1.8GB from one
> hour to the next today.
>
> I have taken the DB and restored it to to a 2008r2 Standard DB w 8GB ram ,
> just so they can work come Monday.
>
> What I would really like to know is what changed from one hour to the next
> inside the database to make it grow by 200 MB in an hour, and if there is a
> tool /utility that can compare the before and after DB files.
>
> thanks
>
>
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
>