Problem On SQL Server Hang
Dec 10, 2007
Hi guys, I am having a serious problem on my SQL server. Assuming there's a web server (Cold Fusion in IIS) connects to my SQL server (SQL server 2005 and million records in it which consider quite big for the db size), it works fine and run smoothly during weekday. However, there will be lots of users accessing the db through my web application (located at my web server) until my web application get hang. Not only that, even I want to access my SQL server from my place using management studio also fail.
I try remote desktop into the SQL server, view the 'Task Manager', it shows 1-2% CPU usage that it takes; and i'm able to open the SQL server using management studio. Therefore, I try to restart my web service( IIS ) , and it still unable to open my web application. However, once I restart the SQL service, my web application is available. This issue happens to me every weekend with several times. It's no point for me to restart the SQL service again and again.
1) What's the reason that I need to restart the SQL service then only I can open the web application? Is it the SQL server
hang or the connection problem?
2) Is it lots of record in the database causing the server gets hang since lots of user accessing the database?
3) Where can I check out the exactly problem on it ? IIS log or SQL log?
Hope can get any assistance from here and get a solution/suggestion from you guys as soon as possible.
Best Regards,
Hans
View 1 Replies
ADVERTISEMENT
Feb 6, 2007
Guys.
Quite a large log attached.
I had 5 servers hang all on the same day, all within about 5 mins of each other scattered across 4 corners of the UK. Our support team tell me that it has something to do with SQL Server, but cannot say what.
I can see looking at the error log of one of the servers, that there are about4 entries everyday since startup, and this continues right up until the night before the freeze.
At 22:00 the night before the freeze, a load of entries are written (Iv'e cut down the list to make it easier to read). then at around 4am the servers all froze.
Could someone take a sneaky peak at these logs and tell me in your own opinion what caused this to happen.
The first section, is what I believe to be normal
2006-11-28 20:52:53.68 server Copyright (C) 1988-2002 Microsoft Corporation.
2006-11-28 20:52:53.68 server All rights reserved.
2006-11-28 20:52:53.68 server Server Process ID is 952.
2006-11-28 20:52:53.68 server Logging SQL Server messages in file 'D:Program FilesMicrosoft SQL ServerMSSQLlogERRORLOG'.
2006-11-28 20:52:53.73 server SQL Server is starting at priority class 'normal'(1 CPU detected).
2006-11-28 20:52:54.75 server Working Set size set to 409600 kilobytes.
2006-11-28 20:52:54.90 server SQL Server configured for thread mode processing.
2006-11-28 20:52:54.90 server Processor affinity turned ON, processor mask 0x1
2006-11-28 20:52:54.92 server Using dynamic lock allocation. [2500] Lock Blocks, [5000] Lock Owner Blocks.
2006-11-28 20:52:55.20 server Attempting to initialize Distributed Transaction Coordinator.
2006-11-28 20:52:57.20 server Failed to obtain TransactionDispenserInterface: Result Code = 0x8004d01b
2006-11-28 20:52:57.53 spid3 Starting up database 'master'.
2006-11-28 20:52:59.31 spid3 Server name is 'SN047483'.
2006-11-28 20:52:59.31 server Using 'SSNETLIB.DLL' version '8.0.760'.
2006-11-28 20:52:59.31 spid5 Starting up database 'model'.
2006-11-28 20:52:59.50 spid8 Starting up database 'msdb'.
2006-11-28 20:52:59.50 spid9 Starting up database 'pubs'.
2006-11-28 20:52:59.53 spid10 Starting up database 'udb'.
2006-11-28 20:52:59.64 spid11 Starting up database 'vgold'.
2006-11-28 20:53:00.07 server SQL server listening on 155.202.58.53: 1433.
2006-11-28 20:53:00.07 server SQL server listening on 127.0.0.1: 1433.
2006-11-28 20:53:00.29 spid5 Clearing tempdb database.
2006-11-28 20:53:00.64 server SQL server listening on TCP, Shared Memory, Named Pipes.
2006-11-28 20:53:00.64 server SQL Server is ready for client connections
2006-11-28 20:53:00.71 spid9 Starting up database 'dbs'.
2006-11-28 20:53:01.01 spid8 Recovery is checkpointing database 'msdb' (4)
2006-11-28 20:53:01.50 spid5 Starting up database 'tempdb'.
2006-11-28 20:53:53.78 spid3 Recovery complete.
2006-11-28 20:53:53.78 spid3 SQL global counter collection task is created.
2006-11-28 20:53:54.32 spid59 Using 'xpsqlbot.dll' version '2000.80.194' to execute extended stored procedure 'xp_qv'.
2006-11-29 00:00:01.10 spid69 Using 'xpstar.dll' version '2000.80.760' to execute extended stored procedure 'xp_instance_regread'.
2006-11-29 02:00:01.54 spid69 Using 'xplog70.dll' version '2000.80.760' to execute extended stored procedure 'xp_cmdshell'.
2006-11-29 02:00:09.31 backup Database backed up: Database: master, creation date(time): 2006/11/28(20:52:57), pages dumped: 1907, first LSN: 159:245:1, last LSN: 159:247:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'QMBACKDEVICE'}).
2006-11-29 02:00:11.46 backup Database backed up: Database: msdb, creation date(time): 2000/08/06(01:40:56), pages dumped: 1667, first LSN: 397:332:1, last LSN: 397:335:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'QMBACKDEVICE'}).
2006-11-29 02:01:58.10 backup Database backed up: Database: dbs, creation date(time): 2004/10/05(08:00:04), pages dumped: 94467, first LSN: 114:53199:1, last LSN: 114:53203:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'QMBACKDEVICE'}).
2006-11-29 02:01:58.20 backup Database log truncated: Database: dbs.
2006-11-29 10:51:33.43 spid62 Using 'odsole70.dll' version '2000.80.760' to execute extended stored procedure 'sp_OACreate'.
2006-11-30 02:00:04.34 backup Database backed up: Database: master, creation date(time): 2006/11/28(20:52:57), pages dumped: 1907, first LSN: 159:260:1, last LSN: 159:262:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'QMBACKDEVICE'}).
2006-11-30 02:00:06.57 backup Database backed up: Database: msdb, creation date(time): 2000/08/06(01:40:56), pages dumped: 1667, first LSN: 398:26:1, last LSN: 398:29:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'QMBACKDEVICE'}).
2006-11-30 02:01:53.84 backup Database backed up: Database: dbs, creation date(time): 2004/10/05(08:00:04), pages dumped: 94467, first LSN: 114:54895:1, last LSN: 114:54899:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'QMBACKDEVICE'}).
2006-11-30 02:01:53.93 backup Database log truncated: Database: dbs.
2006-11-30 13:10:09.96 spid67 Error: 60002, Severity: 15, State: 1
2006-11-30 13:10:09.96 spid67 PBX login_id 5592 already exists in user id 379. Proc Name: um_user_insert.
2006-12-01 02:00:04.51 backup Database backed up: Database: master, creation date(time): 2006/11/28(20:52:57), pages dumped: 1907, first LSN: 159:275:1, last LSN: 159:277:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'QMBACKDEVICE'}).
2006-12-01 02:00:06.76 backup Database backed up: Database: msdb, creation date(time): 2000/08/06(01:40:56), pages dumped: 1667, first LSN: 398:408:1, last LSN: 398:411:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'QMBACKDEVICE'}).
2006-12-01 02:01:52.31 backup Database backed up: Database: dbs, creation date(time): 2004/10/05(08:00:04), pages dumped: 94515, first LSN: 114:55915:1, last LSN: 114:55923:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'QMBACKDEVICE'}).
2006-12-01 02:01:52.39 backup Database log truncated: Database: dbs.
This second section then has around a good few hundred entries.
2006-12-01 22:00:01.98 spid67 Error: 60132, Severity: 15, State: 1
2006-12-01 22:00:01.98 spid67 Folder 7 is not assigned to user 11 Proc Name: ags_workflow_sess_count.
2006-12-01 22:00:02.04 spid67 Error: 60132, Severity: 15, State: 1
2006-12-01 22:00:02.04 spid67 Folder 7 is not assigned to user 11 Proc Name: ags_workflow_sess_count.
2006-12-01 22:18:02.57 spid66 Error: 60132, Severity: 15, State: 1
2006-12-01 22:18:02.57 spid66 Folder 7 is not assigned to user 63 Proc Name: ags_workflow_sess_count.
2006-12-01 22:43:37.42 spid67 Error: 60132, Severity: 15, State: 1
2006-12-01 22:43:37.42 spid67 Folder 7 is not assigned to user 493 Proc Name: ags_workflow_sess_count.
2006-12-01 22:43:37.43 spid67 Error: 60132, Severity: 15, State: 1
2006-12-01 22:43:37.43 spid67 Folder 7 is not assigned to user 493 Proc Name: ags_workflow_sess_count.
2006-12-01 22:44:37.51 spid58 Error: 60132, Severity: 15, State: 1
2006-12-01 22:44:37.51 spid58 Folder 7 is not assigned to user 613 Proc Name: ags_workflow_sess_count.
2006-12-01 22:46:07.00 spid67 Error: 60132, Severity: 15, State: 1
2006-12-01 22:46:07.00 spid67 Folder 7 is not assigned to user 660 Proc Name: ags_workflow_sess_count.
2006-12-01 23:00:20.65 spid58 Error: 60132, Severity: 15, State: 1
2006-12-01 23:00:20.65 spid58 Folder 7 is not assigned to user 949 Proc Name: ags_workflow_sess_count.
2006-12-01 23:00:20.67 spid58 Error: 60132, Severity: 15, State: 1
2006-12-01 23:00:20.67 spid58 Folder 7 is not assigned to user 973 Proc Name: ags_workflow_sess_count.
2006-12-01 23:02:33.07 spid66 Error: 60132, Severity: 15, State: 1
2006-12-01 23:02:33.07 spid66 Folder 7 is not assigned to user 1010 Proc Name: ags_workflow_sess_count.
2006-12-01 23:04:38.10 spid58 Error: 60132, Severity: 15, State: 1
2006-12-01 23:04:38.10 spid58 Folder 7 is not assigned to user 1247 Proc Name: ags_workflow_sess_count.
2006-12-01 23:04:38.12 spid58 Error: 60132, Severity: 15, State: 1
2006-12-01 23:04:38.12 spid58 Folder 7 is not assigned to user 1266 Proc Name: ags_workflow_sess_count.
2006-12-01 23:06:08.59 spid66 Error: 60132, Severity: 15, State: 1
2006-12-01 23:06:08.59 spid66 Folder 7 is not assigned to user 1659 Proc Name: ags_workflow_sess_count.
2006-12-01 23:06:08.59 spid66 Error: 60132, Severity: 15, State: 1
2006-12-01 23:06:08.59 spid66 Folder 7 is not assigned to user 1812 Proc Name: ags_workflow_sess_count.
2006-12-01 23:06:08.59 spid66 Error: 60132, Severity: 15, State: 1
2006-12-01 23:06:08.59 spid66 Folder 7 is not assigned to user 1812 Proc Name: ags_workflow_sess_count.
2006-12-01 23:06:08.60 spid66 Error: 60132, Severity: 15, State: 1
2006-12-01 23:06:08.60 spid66 Folder 7 is not assigned to user 1812 Proc Name: ags_workflow_sess_count.
2006-12-01 23:06:08.60 spid66 Error: 60132, Severity: 15, State: 1
2006-12-01 23:06:08.60 spid66 Folder 7 is not assigned to user 1812 Proc Name: ags_workflow_sess_count.
2006-12-01 23:06:08.62 spid66 Error: 60132, Severity: 15, State: 1
2006-12-01 23:06:08.62 spid66 Folder 7 is not assigned to user 1812 Proc Name: ags_workflow_sess_count.
2006-12-01 23:06:08.62 spid66 Error: 60132, Severity: 15, State: 1
2006-12-01 23:06:08.62 spid66 Folder 7 is not assigned to user 1812 Proc Name: ags_workflow_sess_count.
2006-12-01 23:06:08.62 spid66 Error: 60132, Severity: 15, State: 1
2006-12-01 23:06:08.62 spid66 Folder 7 is not assigned to user 1812 Proc Name: ags_workflow_sess_count.
2006-12-01 23:06:08.62 spid66 Error: 60132, Severity: 15, State: 1
2006-12-01 23:06:08.62 spid66 Folder 7 is not assigned to user 1812 Proc Name: ags_workflow_sess_count.
2006-12-01 23:06:08.64 spid66 Error: 60132, Severity: 15, State: 1
2006-12-01 23:06:08.64 spid66 Folder 7 is not assigned to user 1812 Proc Name: ags_workflow_sess_count.
2006-12-01 23:06:08.64 spid66 Error: 60132, Severity: 15, State: 1
This section shows from 4am onwards
2007-01-13 04:05:09.87 spid71 Error: 60132, Severity: 15, State: 1
2007-01-13 04:05:09.87 spid71 Folder 7 is not assigned to user 613 Proc Name: ags_workflow_sess_count.
2007-01-13 04:05:13.40 spid75 Error: 60132, Severity: 15, State: 1
2007-01-13 04:05:13.40 spid75 Folder 7 is not assigned to user 660 Proc Name: ags_workflow_sess_count.
2007-01-13 04:05:16.15 spid77 Error: 60132, Severity: 15, State: 1
2007-01-13 04:05:16.15 spid77 Folder 7 is not assigned to user 660 Proc Name: ags_workflow_sess_count.
2007-01-13 04:05:17.29 spid61 Error: 60132, Severity: 15, State: 1
2007-01-13 04:05:17.29 spid61 Folder 7 is not assigned to user 660 Proc Name: ags_workflow_sess_count.
2007-01-13 04:05:18.12 spid69 Error: 60132, Severity: 15, State: 1
2007-01-13 04:05:18.12 spid69 Folder 7 is not assigned to user 63 Proc Name: ags_workflow_sess_count.
2007-01-13 04:10:28.81 spid51 Unable to load OLE/DB initialization service.
2007-01-13 04:58:12.21 server Error: 17883, Severity: 1, State: 0
2007-01-13 04:58:12.21 server The Scheduler 0 appears to be hung. SPID 0, ECID 0, UMS Context 0x250A5C68.
2007-01-13 04:59:12.21 server Error: 17883, Severity: 1, State: 0
2007-01-13 04:59:12.21 server The Scheduler 0 appears to be hung. SPID 0, ECID 0, UMS Context 0x250A5C68.
2007-01-13 05:00:12.21 server Error: 17883, Severity: 1, State: 0
2007-01-13 05:00:12.21 server The Scheduler 0 appears to be hung. SPID 0, ECID 0, UMS Context 0x250A5C68.
2007-01-13 05:01:12.21 server Error: 17883, Severity: 1, State: 0
2007-01-13 05:01:12.21 server The Scheduler 0 appears to be hung. SPID 0, ECID 0, UMS Context 0x250A5C68.
2007-01-13 05:02:12.21 server Error: 17883, Severity: 1, State: 0
2007-01-13 05:02:12.21 server The Scheduler 0 appears to be hung. SPID 0, ECID 0, UMS Context 0x250A5C68.
2007-01-13 05:03:12.21 server Error: 17883, Severity: 1, State: 0
View 9 Replies
View Related
Sep 30, 2004
Hi,
I am using Windows 2003 Standard Server (stand alone) and trying to install SQL Server 2000 Enterprise edition. The installation stops whenever I have entered the sa password (the dialog box disappeared and then nothing happed, but the "setupsql" process (something like this) is still there).
The same happened when I install SQL Server 2000 in Windows 2000 Server. For Win2K, I can first install SQL Server 7.0 and then upgrade to 2000 (same SQL Server 2000 installation CD!). However, Windows 2003 doesn't support SQL Server 7.0. So I can't use this method...
Any idea?
Thanks.
Michael
*I have turned off Norton already.
View 3 Replies
View Related
Dec 2, 2004
Greetings everybody,
lately we are experiencing some very strange behaviour on the part of our
SQL-Server.
We are using SQL-Server as a combined Database for one COM+ application and one J2EE-Application. All of this is installed on the same machine (dual-CPU, 2 GB RAM).
This setup has been up and running for almost a year now.
In the last two weeks there have been incidences where the performance of SQL-Server is decreasing steadily until it finally hangs completely (just SQL-Server, not the machine itself).
This happens 2-3 times a week, curiously always between 9 and 10 a.m.!
After stopping and restarting the actual SQL-Server "Service", everything is back to normal (until the next morning or the morning after that).
There are a few automated batches that access the database via the COM+ Server. These run at night and are completed before work begins at ca. 7 a.m.
Profiler-Logs show a few "Escalate Locks", but those alone cannot account for this strange behaviour.
Any help or info would be greatly appreciated.
View 4 Replies
View Related
May 31, 2008
Dear All,
SQL Server 2005 a lot of time hangs. Any advice is highly appreciated!
Please have a look at the error log from this link http://download.yousendit.com/B787CBD235FC2417
Regards,
LG
View 5 Replies
View Related
Apr 1, 2008
Hi there.
When I try to free previously registered DLL, server is starting to execute query and it takes a number of minutes and nothing happens.
Here is an example:
sp_addextendedproc 'xp_test','test.dll' //works fine
exec master..xp_test '999' //works fine
sp_dropextendedproc 'xp_test' //works fine
dbcc test(free) //do not work
I've tested it on:
SQL MSDE SP3 //i was getting an acces violation first: spid 51 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at 0x00000000
SQL MSDE SP4 //but on this SP I have the same behaviour as on server 2005 / infinite query execution time
SQL Server 2005 standard //infinite query execution time
SQL Server 2005 standard with SP2 //infinite query execution time
I can't understand this because this started after chaning my machine.
It worked without any problems on the previous one and I've used this metod very often on the same dll which hasn't changed.
Is there any way to solve this?
Thanks for your time.
View 9 Replies
View Related
Oct 13, 2015
SQL server DB server is in hang state. Is this is due to high memory utilization?
View 9 Replies
View Related
Jul 24, 2007
does anyone has idea why the server hang when i try to drop merge subscriptions?
any suggestion would be appreciate.
thanks.
View 1 Replies
View Related
Jun 11, 2008
Hai -
Currently i am do sql server 2005 failover cluster installation on win 2003 server.
It is showing preparing to install please wait and there is no progress from last two hours.
Is there any way to check whether installation is going on or where can i check log files for this installation.
Please advise asap.
Cheers:)
vsh
View 7 Replies
View Related
Sep 1, 2006
Hi,
I am running the following TSQL command and it hangs. These commands are running from SQL 2000 server and it is querying information for SQL20005 database.
Running simple EXEC command work fine but running using Insert hangs.
Set @Cmd = @ServerName + '.' + @dbname + '.dbo.sp_helpntgroup'
Print @Cmd
Insert into dbo.DBSecurity ( NTGroupName, NTGroupID, SID, HasDbAccess)
Exec (@Cmd)
Any idea,
View 2 Replies
View Related
Jan 12, 2006
Hi Everyone,
I'm having a bit of a dispute with one of my clients' software developers.
This client has a server, installed by us (Windows 2003 Std. SP1/ SQL 2000 SP3a) (Dual Xeon 2.8, 4GB RAM)
They are having performance issues with the software developers application, which is based on SQL.
I'm having trouble believing the issues are caused by the server, but the software dev's blaming us for the problems.
Yesterday i got a mail from them that a specific SQL query "hangs" upon execution and this is likely caused by a bad install of the server or SQL (yeah right). This query is: select * from table, wich hangs the server upon running. Theyt say a select row(item) from table does work (duh).
Now i know a bit of SQL and i'm thinking this select all from that table query locking up the server is most likely caused by a table that has grown so big that it just locks up.
Am i right thinking this has nothing to do with the hardware/software (sbs/sql), but is merely caused by bad programming and/or lack of SQL knowledge at the dev's side? Especially since last year the DB grew to about 40 GB and i had to tell them to think about putting it in simple mode to make it smaller. Something they'd never heared about...
Any ideas would be very welcome.
I don't want to go throw mud around with us blaming them and them blaming us and the client being the one with the problems.
I just want to make a well thought out statement to the software dev. and then try to find the right solution.
Thanks,
Dennes
View 3 Replies
View Related
Apr 10, 2006
Hi Guru,Our HR sql 2000 production server is 800.760 built (SP3a) with 2GB ofRAM and 2 CPU hiper threading. This server is very low activity whereprocessor runs average 1-3 during the day. However, in the last twomonths, I've seen the following message occurred a few times on thisserver.Error: 17883, Severity: 1, State: 0The Scheduler 2 appears to be hung. SPID 0, ECID 0, UMS Context0x0381F660.I did extensive research and read both KB 815056 and 10885 but I couldnot correlate these KBs in to my issue. The reason is, I don't thinkour server is very busy to cause the checkpoint process to be delayed.The database keeps growing only 5-10MB in a week and I allocated thespace during off hour.What is the solution to fix this issue? Will I fix this issue byapplying the hotfix MS03-031?Thanks so much,Silaphet,
View 1 Replies
View Related
Jul 26, 2006
hi,everyone!I meet strange thing when I create a maintance job for backup alldatabase.and this backup job just stands "Executing job step '(step 1)'" for averylong time .SQL server startup account is this account for network bakcupafter I issue sp_databases sp, I found my full database size only 1GB,and I found my backupfile is complete.I view event log and Sql server Log and no found error!why do it take so long time, but stands 'executing ' status and neverfinish.help me!best regards!
View 1 Replies
View Related
Jan 28, 2008
My SQL CE Replication is hanging during a full CreateDatabase download. My SDF file is around 13 MB loaded onto an SDIO card. I need to be able to blow away the SDF file and fully reload from remote locations.
I get all of the table 'upload' and 'download' async events and it appears to be working but then just hangs until I guess the device runs out of memory. I get several beeps and then the hourglass. After a reboot, the DB file is not usable.
I've been using SQL CE 3.0 for awhile and it has worked ok in the past. I upgraded to SQL CE 3.5 but I see the same behavior.
My replication data consists of about 30K inserts across about 30 tables.
Any ideas on how to debug a problem like this? I'm really stuck with this bug.
thank you
View 14 Replies
View Related
Sep 8, 2006
I sumbit a package A in MSDB in SQL2005 EE server with SP1 by dtexec.
Package A called 2 packages B and C in MSDB to do some data flow task.
The package A finished successfully in about 2 to 3 mins.
Howerver, when I submitted the package A again. Package A hanged.
I checked the Activity Monitor and found all related Package A, B, C task is sleeping.
I killed the dtexec and then re-submit the package A. Package A finished successfully this time in expected duration.
It is strange.
Could anyone tell me the reason of hanging?
Thank you very much.
View 2 Replies
View Related
Dec 28, 2007
I have a job that FTP's a backup file offsite daily. Sometime the job hangs (for undetermined reason). The job never terminates. Is there ar way to force termination of the job after so many minutes? This is a Operating System command job.
I see the parameter "Shutdown Timeout Interval" in SQL Server Agent - currently set to 15 seconds. This apparently is not used or not working, as my job was hung for several days and it was not detected. The job runs daly. Since the prior run was "still running - hung", it didn't start, causing my offsite backups to fail following the job hang.
How can I force termination of a job if it doesn't complete in so many minutes?
View 3 Replies
View Related
Jul 13, 1998
Hi,
excuse me if this problem has been discussed before!
We handle the addmittance in our university with IIS 4.0 and MS SQL Server 6.5 ... a group of 12 operators keep the server busy entering the information about students...
I run backup of the hole database on every 1 hour in order to have a recent copy of the date base in case the disk fail (we had bad luck with a quantum HDD few weeks ago).
The problems begun when the data base got to 18 MEGs and at about 32 connections to the SQL server when the dump finish the server goes out...
Anyone heard about this before and how to handle it?
Yours truly WarJo
PS: Sorry for my englsih... not good enought
View 1 Replies
View Related
Feb 23, 2004
hello:
My situation is
(1) I upgraded MS SQL 7.0 from original edition to SP 4
(2) DTS packages which download data from an oracle server work fine both on a remote machine and on the Server
(3) When these packages are scheduled to run as jobs they do not succeed and do not fail they just keep running e.g for 58 hours over the weekend
(4) even if I start the job on the server I still get the same behaviour:
Can anyone help please?
View 6 Replies
View Related
Nov 30, 2015
We have initiated reinitialize subscription by which snapshot agent is started and hanged at 26%.We have a publication of 6 articles, transactional replication, using SQL Server 2008R2.
View 3 Replies
View Related
Apr 20, 2006
Hi All,
I have a problem with a DTS package to import data from one of our Ingres based Databases.
I've recently moved the DTS package from one server to another and recreated the Ingres ODBC Settings, which are all OK.
When I run the package through EM and the CMD line, it runs OK, but not as a scheduled task.
I've had a look at a KB Article Q318819 and followed the steps about package threads on 3rd party drivers, but this doesent help, nor does making sure DTSRun isnt in the current task list.
Could anyone help me out please?
TIA.
View 2 Replies
View Related
Mar 27, 2006
Hi.. We have a java application which connect to our MS-SQL DB during midnight using JDBC connector and extract information. But very often ,the java applicatian halted and because of the deadlock as shown below.
Caused by: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Transaction (Process ID 54) was deadlocked o n lock resources with another process and has been chosen as the deadlock victim.
now the java programmer is blaming me that the MS SQL DB is having deadlock and cause their Java application to hang.
Is there any way to clear the deadlock before the the Java applcation run or how to prove the Java application script itself is having problem and causing the deadlock ?
View 2 Replies
View Related
May 15, 2007
Hi,
I have 2 SQL 2005 database servers working together as a mirrored configuration.
Accessing this database I have an Apache Tomcat 5.5 server using SQL JDBC 1.1 driver. When the database is running in a non-failover state everything works fine and my Tomcat application (uPortal) runs as expected. However, when the database is failed over, my Tomcat application hangs indefinitely; even after restarting Tomcat following the failover.
This is how my connection string looks in the server.xml of Tomcat:
jdbcqlserver://**.**.**.165:1384;failoverPartner=**.**.**.97;port=1384;DatabaseName=myUWE;Language=English
I can connect to the failoverPartner once it becomes the principal server after a failover.
Has anyone experienced this before, or have any suggestions that I can try to resolve this issue?
Many Thanks,
Nick
View 1 Replies
View Related
Sep 20, 2007
Greetings,
This morning one of our jobs failed, so I eventually ran the SSIS package manually and found the flow "hanging" at a script task. The fix was to open the script in design mode and hit Save, which I believe compiles the code. Then the package ran as it has normally for several months.
There was a recent Windows update run on this server. I don't know what was updated, as it was the DBA that did that. It seems possible that a .NET framework update would cause this problem, does anyone have any thoughts on this or anything else causing this?
Given the extent of some SSIS environments, and ours is pretty extensive, this could be a real pain to go in and manually recompile each and every script task.
Thanks
View 5 Replies
View Related
Jul 31, 2006
Hi ,
I have an issues that worries me alot. I have SSIS packages scheduled in SQL Agent and they sometime error out or hang in Agent but never when i run them in BI IDE (Visual studio). There are two particular packages that always hang, alway in Agent but when i run them in BI IDE, they run just fine. Im was running them under in Agent under type= Sql server intergration services and also tried running under type = Operating System (CmdExec). Both types have the same problem. The packages hang. The log files dont say much, because the packages hang, no logging is doing so i dont get any infomation to determin what is going on. Can someone please help me ou.
View 7 Replies
View Related
Aug 12, 2015
I've been put in charge of a SQL server recently and I'm completely new to maintaining SQL. For some reason several clients when they are doing their database processing I get network_io hangs and everything comes to a halt. I have to go in there and manually kill the SPID and everything continues where it left off.
SQL Setup
Server 2012 R2
SQL 2014 SP1
Dell 850
VM running in Hyper-V
50GB RAM
FusionIO Card
10GB Ethernet between clients and server
All workstations are pretty much
Windows 7/8.1
10GB
64+GB of RAM
Several CPUs
SSD and SATA hard drives
It's very hit or miss when this occurs as well, however, it's always the same NETWORK_IO cause.
I've read on the Internet about how the client keep up with what SQL is sending. Could this be poor programming or do I need to investigate my network setup?
View 2 Replies
View Related
May 16, 2007
hi,
I'm creating my first report.
I do "new project" > "report server project".
Thereafter I create my shared datasource.
Thereafter I try to add a new report.
It ask to enter my querry.
I've built up my querry previously with the querry analyser in SSMS, and there it runs quite fast.
But when i copy-paste the querry in the reporting designer, and i choose to preview it, it takes more then 20 minutes.
however, my querry it quite big, but i've written querries ten times larger in my life.
(it's about 50lines: 10 querries, union-ed together and in each one i have 4 innerjoins.... all tables are even almost empty, so it's not that indexes are missing or whatever)...
is it known that in the report designer querries are much more slower????
View 3 Replies
View Related
Jan 1, 2000
When I move an SQL group to the other cluster member, it seems that the ODBC connections hang on the client web servers, and do not process any queries until they are rebooted. I'm using IIS/Cold fusion web servers with an SQL 7.0 Cluster (MSCS). Any ideas why this may be happening?
Thanks,
Steve Johnson
View 2 Replies
View Related
Aug 27, 2015
When SSL is enable on SQL Server (Force Encryption = Yes). Connecting to SQL Server via JDBC using the open source driver jTDS driver take a while and eventually hang or timeout. I tried using jtds-1.2.8-dist and jtds-1.3.1-dist. In the connection property, I added "ss=request". I also tried with "ssl=require".
I am using SQL Server 2012 SP2 and SQL Server 2014 SP1. Samething happen in SQL Server 2005 as well.
I am using this JAVA version "ibm-java-x86_64-sdk-7.0-9.10"
I know this used to work for me when we where using "ibm-java-x86_64-sdk-7.0-8.0"
This is my connection string:
net.sourceforge.jtds.jdbc.Driver
jdbc:jtds:sqlserver://fqdn:1433/master;USENTLMV2=true;SSL=request;
View 0 Replies
View Related
Feb 16, 2005
Need to parsing serverName and databaseName to run a dynamic query to get serverName and databaseName and employee_ID via a accountID parameter.
-----------------------------
declare @stringSQL varchar(200)
select @stringSQL=
'insert into temp1 select '+@AccountID+' accountID, employee_ID from ' + @serverName +'.dbo.'+@databaseName+'.tblEmployee where inactive=0'
print @stringSQL_GetUserName
exec (@stringSQL_GetUserName)
select * from temp1
------------------------------
above dynamic query works fine.
Howevery, this should be run only under insertion event. When I put it in a proc to run within the insertion trigger or put the whole sql statement within the trigger:
1. when ran at a MSDE server
MSDTC on server is unavailable.
2. when ran at a SQL2000 developer testing server with the distributed transaction coordinator on, the insertion a record in the isql/w hang there. Could not even to kill this query, and have to stop and restart the SQL server.
Then I just want to return the dynamic query result without 'insert into temp1 ', the result is still hang...
Is there a way to let the insert trigger to run a dyanamic query which linked to around 10 servers?
thanks
David
View 4 Replies
View Related
Jul 20, 2005
Details:MS SQL 2000 dual Intel 1.2 GHz processors.1 GB RAM2.1 GB dBDynamic Memory Managment.No other apps running on this server.First question:Since I have Dynamic Memory Managment setup, Is it usuall that thesqlsrv.exe process on the server steadily climbs and is in the 800 to900 MB range. There is only about 20 MB free. In theory this is howDMM can work, but do people really see it work this way.Second question:I had users complaining about lockups in the app I have to supportthat connects to this dB. At first I thought it was the large use ofmemory, but once I was able to see in Enterprise Manager that therewas process blocking several other processes. EM then locked up and Icouldn't get to the details of what the exact process was that wasdoing the blocking. After restarting SQL services things were fine.When I checked the logs there was nothing there about a hung process.The logs seemed very sparse. Why would there not be anything in thelogs about it. The logs actually seem very thin on any information.Thanks,T.
View 1 Replies
View Related
Sep 1, 2015
Below the Error Log Reported in SQL Agent (64 bit SQLServer 2008R2 Enterprise Edition Service pack 2 ,32Core CPU Numa Node and 64GB Ram
[298] SQLServer Error: 10054, TCP Provider: An existing connection was forcibly closed by the remote host. [SQLSTATE 08S01]
[298] SQLServer Error: 10054, Communication link failure [SQLSTATE 08S01]
[165] ODBC Error: 0, A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections.
For more information see SQL Server Books Online. [SQLSTATE 08001]
[382] Logon to server '(local)' failed (ConnUpdateStartExecutionDate)
View 2 Replies
View Related
Sep 10, 2007
How to prevent the hang on the initator service broker if the target service broker is not started?
Our case has two service brokers (two databases), sometime, the target is need to turn off. But the sitation is the initator service broker (in fact, the message is sent from triggers) become hang, I want to prevent this case and continue to operation, and the messages should queue and will continue to send to target service broker when it startup. How should I do?
View 3 Replies
View Related
Dec 28, 2007
Hi,
I'm trying to implement an incremental data pull (Oracle to SQL) based on Andy's blog:
http://sqlblog.com/blogs/andy_leonard/archive/2007/07/09/ssis-design-pattern-incremental-loads.aspx
My development machine is decent: 1.86 GHz, Intel core 2 CPU, 3 GB of RAM.
However it seems the data flow task gets hung whenever I test the package against the ~6 million row source, as can be seen from these screenshots. I have no memory limitations on the lookup transformation. After the rows have been cached nothing happens. Memory for the dtsdebug process hovers around 1.8 GB and it uses 1-6 percent of CPU resources continuously. I am not using fast load to insert new records into my sql target table. (I am right clicking Sequence Container 3 and executing this container NOT the entire package in the screenshots)
http://i248.photobucket.com/albums/gg168/boston_sql92/1.jpg
http://i248.photobucket.com/albums/gg168/boston_sql92/2.jpg
http://i248.photobucket.com/albums/gg168/boston_sql92/3.jpg
http://i248.photobucket.com/albums/gg168/boston_sql92/4.jpg
http://i248.photobucket.com/albums/gg168/boston_sql92/5.jpg
http://i248.photobucket.com/albums/gg168/boston_sql92/6.jpg
The same package works fine against a similar test table with 150k rows.
http://i248.photobucket.com/albums/gg168/boston_sql92/7.jpg
http://i248.photobucket.com/albums/gg168/boston_sql92/8.jpg
The weird thing is it only takes 24 minutes for a full refresh of the entire source table from Oracle to the SQL target table.
Any hints,advice would be appreciated.
View 18 Replies
View Related
