[dba-SQLServer] SQL Server hanging

Also set the db to 'Simple' recovery model,
drop all indexes,
make sire the db + log files are big enough not to need auto-growing, 
turn off auto grow?
You can also set the number of parallel tasks (need to experiment with
this one),  
Set priority to high,
turn off logging,
maybe fiddle with the Transaction isolation level, chaos sounds
good...lol

As others have suggested use a global for the path changes.

cheers

Michael M


-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of
Francisco Tapia
Sent: Friday, 11 August 2006 4:40 AM
To: dba-sqlserver at databaseadvisors.com
Subject: Re: [dba-SQLServer] SQL Server hanging

excellent,
  I also use the following to shrink the log files

BACKUP LOG DB_NAME WITH TRUNCATE_ONLY
DBCC SHRINKFILE ('DB_NAME_LOG', 10)

if you are unsure of what the database log filename is, do a "Select *
>From sysfiles" in the database where you need to shrink the log file.


On 8/10/06, artful at rogers.com <artful at rogers.com> wrote:
>
> Use DCC SHRINKFILE or DBCC SHRINKDATABASE. Note that shrinking the log

> doesn't always do what you might excpect, since it is based on the 
> size of the virtual logs. There is a good explanation of this (and how

> to get around
> it) in BOL under the topic "Shrinking the Transaction  Log".
>
> HTH,.
> Arthur
>
> ----- Original Message ----
> From: JWColby <jwcolby at colbyconsulting.com>
> To: dba-sqlserver at databaseadvisors.com
> Sent: Wednesday, August 9, 2006 8:39:51 PM
> Subject: Re: [dba-SQLServer] SQL Server hanging
>
> It turns out it was just thinking.  Unfortunately I am now totally 
> confused on which files succeeded and which failed.
>
> Arthur, I do think that adjusting the number of records that are 
> imported before a commit is a grand idea.  I also need info on how to 
> shrink the log file.  As you might guess I am still muddling through 
> this SQL Server thing.
>
> John W. Colby
> Colby Consulting
> www.ColbyConsulting.com
>
> -----Original Message-----
> From: dba-sqlserver-bounces at databaseadvisors.com
> [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of 
> JWColby
> Sent: Wednesday, August 09, 2006 3:52 PM
> To: dba-sqlserver at databaseadvisors.com
> Subject: [dba-SQLServer] SQL Server hanging
>
> Is there any way to tell what is going on with SQL Server when it
hangs?
>
> I am trying to import these tens of millions of records into SQL
Server.
> They are flat file comma delimited text files, 3 million recs / file.
> Everything is working fine, I have ~12 files imported (36 million 
> records) and I am humming along.  I have about 6 import processes 
> running (import and export data manager) at once and of course things 
> slow down but suddenly none of the imports is progressing at all.  I 
> try to connect with EM and when I try to expand the "databases" tree 
> it gives an error connecting, "unable to obtain a lock" or some such.

> I let the import functions continue to run but 20 minutes later still 
> not a single more record imported.  So I use task manager to shut down

> all of the import processes, shut down EM, shut down the SQL Server 
> manager normally, unload it, shut off the computer, restart it.  Try 
> to connect with enterprise manager and no go.  In fact it APPEARS to 
> be locked up.  When I go in with task manager and look at the process,

> it is slowly gaining "memory used" until it basically runs out then 
> starts increasing the page file size, until that hits about 1.7g and 
> then that too stops incrementing but EM is still hung.
>
> CPU usage is now down about 2%, no "more" memory being grabbed by EM, 
> the page file is static, but EM is hung.
>
> I need to find out what is going on here.  I have about 12 of these 3 
> million record text files imported and don't want to have to clean it 
> out and start over, but worse, I have no clue why it stopped working.

> Is there any (free) tool that will tell me what SQL Server thinks it 
> is up to?  If I can't get EM to see the databases I am basically hosed

> here.
>
> John W. Colby
> Colby Consulting
> www.ColbyConsulting.com
>
> _______________________________________________
> 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
>
>
>
>
>
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
>


--
-Francisco
http://pcthis.blogspot.com |PC news with out the jargon!
http://sqlthis.blogspot.com | Tsql and More...
_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com