[dba-SQLServer] SQL Server is hopelessly slow

John W. Colby jwcolby at colbyconsulting.com
Sat Sep 11 06:25:17 CDT 2004


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







More information about the dba-SQLServer mailing list