[dba-SQLServer] Very Long Opening Time for SQL Express

check the size of the transaction logs, they maybe overgrown, and causes
slow performance, in general they ought to be 10% of the data files, to
shrink them do a

backup log databasename with truncate_only -- this empties the log but the
space is still reserved
followed by
dbcc shrinkfile ('transaction log logical name', 1) -- replace the 1 with
whatever 10% of your datafile is.


-Francisco
http://sqlthis.blogspot.com | Tsql and More...


On Mon, Nov 9, 2009 at 11:01 AM, Dan Waters <dwaters at usinternet.com> wrote:

> I have a fast PC I built about two years ago. XP Pro, Quad core, 2 Gb fast
> ram, etc.
>
> It has opened very quickly in the past.  Also, even opening a small table
> to
> look at data is quite slow in addition to a slow opening.
>
> Management Studio did open this morning in about 7 or 8 minutes, not 20 or
> 30.
>
> Thanks!
> Dan
>
> -----Original Message-----
> From: dba-sqlserver-bounces at databaseadvisors.com
> [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Francisco
> Tapia
> Sent: Monday, November 09, 2009 10:27 AM
> To: Discussion concerning MS SQL Server
> Subject: Re: [dba-SQLServer] Very Long Opening Time for SQL Express
>
> what is your hardware configuration and OS you are working on?
>
> --
> Francisco
> On Nov 9, 2009, at 8:10 AM, Dan Waters wrote:
>
> > When I open SQL Express on my PC, it can take 20 or 30 minutes to
> > finally
> > open to where I can work.
> >
> > I have TCP/IP and Shared Memory enabled.
> >
> > What could be causing this?
> >
> >
> >
> >
> > _______________________________________________
> > 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
>
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
>