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

Dan Waters dwaters at usinternet.com
Wed Nov 11 14:58:36 CST 2009


Hi Francisco,

I finally got a chance to try this.  Both my mdf and ldf files for the only
database I have are about 30 Mb in size.  I suspect that this is not an
issue for SQL Server if everything else is going well.

Also, when I opened the Back Up Database window, under Options, the two
options under Transaction Log choices, Truncate the transaction log and Back
up the tail of the log, are both disabled.

By the way, what is DBCC?  At my customer's site I've been getting errors
trying to do certain things because I don't have 'DBCC Permissions',
although I am the owner of that database in SQL Server.  The DBA there says
that she doesn't understand this, and is currently to busy too investigate.
Any thoughts on this problem?

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 9:32 PM
To: Discussion concerning MS SQL Server
Subject: Re: [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
>
>
_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com




More information about the dba-SQLServer mailing list