[dba-SQLServer] SQL Server is hopelessly slow

John

How about using the command line tools and see if that speed up operations. 
That was one of the recommendations from MS when working with large dbs., 
Not to use EM at all.

Martin


----- Original Message ----- 
From: "John W. Colby" <jwcolby at colbyconsulting.com>
To: <dba-sqlserver at databaseadvisors.com>
Sent: Saturday, September 11, 2004 12:25 PM
Subject: [dba-SQLServer] SQL Server is hopelessly slow


>I have this mongo database.  Regardless of what I do it seems, SQL Server
> takes FOREVER to do anything.  To the point where it appears that it is
> locked up.  Is there ANY way to get EM to display a status of what it is
> doing so that I can even know that is doing something at all?  Is there 
> any
> way to break EM when it appears to be hung.  This thing is just unworkable
> as it is.  I will try to do something (anything it seems) and EM locks the
> entire damn machine up.  No incrementing status, nothing except the busy
> cursor.
>
> I have built a smaller set of "just" 3 million records.  It does the same
> thing.  I need to get work done on this thing, set up indexes on fields, 
> do
> data cleanup.  It simply isn't going to work if everything I do locks the
> machine up for a week.
>
> I have to believe I have some setting(s) wrong for SQL Server itself.  My
> hardware is an Athlon64 3.0ghz with 2.5g RAM.  The machine itself is very
> close to as fast as you are going to get on a desktop machine.  Everyone
> says "3 million records is nothing to SQL Server" but you couldn't prove 
> it
> by me.  Can anyone help me troubleshoot this thing and figure out what I 
> am
> doing wrong?
>
> John W. Colby
> www.ColbyConsulting.com
>
> -----Original Message-----
> From: dba-sqlserver-bounces at databaseadvisors.com
> [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Julie
> Reardon-Taylor
> Sent: Friday, September 10, 2004 10:01 AM
> To: dba-sqlserver at databaseadvisors.com
> Subject: Re: [dba-SQLServer] SQL Server Backup
>
>
> John,
>
> I use Veritas 9.0 with Sql Server module as well as their Intelligent
> Disaster Recovery.  Both products have been very reliable.  We are backing
> up to tape.  Easy to set-up and easy to schedule.  It allows for 
> transaction
>
> log backups as well as full database backups.  They will let you download 
> a
> free evaluation copy-works for 30 days.
>
>
>
> Julie Reardon-Taylor
> PRO-SOFT OF NY, INC.
> 108 Franklin Street
> Watertown, NY 13601
> (315) 785-0319
> www.pro-soft.net
>
>
> _______________________________________________
> 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
>
>