[dba-SQLServer] DB growth spurt/Comparison tool

[J- P]

I agree with the execution plan and queries, however, I'm running into a brick wall because I am NOT qualified to look at these queries, hash joins, or execution plans and see where they are flawed, and the "DBM" refuses to acknowledge it and  says "it's lack of resources we need full SQL"

I told them  sure you can throw money at the problem , but that's addressing the symptoms not addressing the cause.





> From: fhtapia at gmail.com
> Date: Mon, 11 Apr 2016 20:30:27 +0000
> To: dba-sqlserver at databaseadvisors.com
> Subject: Re: [dba-SQLServer] DB growth spurt/Comparison tool
> 
> 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
> >
> >
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>