John W. Colby
jwcolby at colbyconsulting.com
Wed Aug 18 15:56:21 CDT 2004
I am trying to add a "PK" autoincrement to this huge db I'm working with. There are around 6 million records at the moment. I went in design view and added the field, then "saved" the table and it took off adding the new field and putting values in the table. The problem is it is taking FOREVER (running for many hours so far) and is not giving any status indicator to say when it will be done. I absolutely must "get back to work doing some stuff in the db. If I "close" enterprise manager in the middle, will it damage my db? I am assuming not but don't want to take any chances. It appears that the reason it is taking so long is extensive use of the swap file. Enterprise manager is currently using 421 mbytes on a 512m machine. I would go somewhere and buy some 512mb sticks if it will help (and it appears it will). 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 Michael Maddison Sent: Wednesday, August 18, 2004 3:25 AM To: dba-sqlserver at databaseadvisors.com Subject: RE: [dba-SQLServer] Multi-processor Depending on the version of SQL. IIRC you can always use 2, the higher end versions depend on OS and such but vary from 4 to 8. Zeons with hyperthreading show up as 2 cpu's in taskmgr which is cool but not fully utilised till Win 2003 server... check BOL cheers Michael M Yes, Sql Server will use multiple processors _______________________________________________ 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