[dba-SQLServer] Access disconnecting from sql express DB

I am making the changed on the 2003 server as per the article, 
One thing that has me puzzled is that looking at the memory usage of sqlserv.exe its at 1.5gb, i thought sql express was limited to 1 GB of memory , or did I misunderstand what I read?

 

 

 

 

 

 

 

 

 

Jean-Paul Natola

 


> From: fhtapia at gmail.com
> Date: Wed, 14 Aug 2013 06:39:20 -0700
> To: dba-sqlserver at databaseadvisors.com
> Subject: Re: [dba-SQLServer] Access disconnecting from sql express DB
> 
> so to help troubleshoot your version of windows 2003 r2 and the sql server
> engine, follow the tips in this kb
> 
> http://support.microsoft.com/kb/942861
> 
> and report back if any of it helps (or is unhelpful).
> 
> good luck!
> 
> -Francisco <http://twitter.com/seecoolguy>
> 
> 
> 
> 
> On Wed, Aug 14, 2013 at 6:36 AM, Francisco Tapia <fhtapia at gmail.com> wrote:
> 
> > Hey JP,
> >  I would grow the log to at least 10%, this will keep it from fragmenting
> > too quickly, in general this is the size you want for your transaction
> > log.  (the exception is if you perform large table modifications that eat
> > up larger than the 10% size you set up)
> >
> > lastly, if you can I would build a small c# windows app, that hooks into
> > your database.  and have it email you or alert you whenever it disconnects
> > from the server.  The problem you are experiencing may still be database
> > engine related.
> >
> >
> > -Francisco <http://twitter.com/seecoolguy>
> >
> >
> >
> >
> > On Tue, Aug 13, 2013 at 7:54 PM, J- P <jnatola at hotmail.com> wrote:
> >
> >> So I changed recovery to simple, did a shrink via smss and selected log,
> >> shrink, reclaim unused space
> >> and WOW did it shrink, it went down to 1MB , thats not even 1 % , much
> >> less 10% of the DB size (hope I didnt muck it up)
> >>
> >> Then
> >>  I reverted back to full recovery , ran a full backup and a log backup
> >> and its still working, as far as versions they are the following ;
> >>
> >> 2003 r2 sp2
> >> sql 9.0.5000 sp4
> >>
> >> What
> >>  are items I should look for in a trace that should be considered
> >> "flags" - this DB started in access 97, went through many hands and
> >> "coders" (using the term loosely,) then went to sql express , and the
> >> front end has gone from Access 97 to 2000, , xp, 2003, and now on 2010
> >>
> >> So there are many places that it could go wrong- If I were to open a PSS
> >> case, should I open  an Access 2010 case or SQL case?
> >>
> >>
> >>
> >>
> >> _______________________________________________
> >> 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
>