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