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

Francisco Tapia fhtapia at gmail.com
Wed Nov 11 17:23:38 CST 2009


DBCC : Database console command

On the security issue That's because you are only a database owner and  
not a system admin

Sent from my mobile

On Nov 11, 2009, at 12:58 PM, "Dan Waters" <dwaters at usinternet.com>  
wrote:

> 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
>
> _______________________________________________
> 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