Mark Rider
ridermark at gmail.com
Sat Sep 11 08:53:42 CDT 2004
Have you downloaded / installed / used Books Online (BOL)? There is a LOT of information on what to do and how to do it in there, and it has taught me a LOT about what I have done wrong. It is a free download from MS at http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp You have a 64 bit processor, but are you running Windows Server 2003? That has the ability to take advantage of the processor architecture better than any other OS. The only other thing I can offer is that you give it some time and patience. I deal with about 25 million rows of data every day, and when DTS gets rolling along it seems to just sit there after the initial CSV import to the table. There is a lot going on behind the scenes, and I have learned (the hard way) that stopping the import and trying to start over will take more time than walking away for a while and coming back to the machine later. On Sat, 11 Sep 2004 07:25:17 -0400, John W. Colby <jwcolby at colbyconsulting.com> wrote: > 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 > > -- Mark Rider http://commonsensesecurity.info