TechArena Community

TechArena Community (http://forums.techarena.in/)
-   Software Development (http://forums.techarena.in/software-development/)
-   -   System Time sync Vs SQL (http://forums.techarena.in/software-development/1475813.htm)

tushar.de7 16-10-2014 12:30 AM

System Time sync Vs SQL
 
Do the System time service's time synchronization hamper s the SQL server or its instance. At the time of running System time service a SQL based application in the client pc is getting hang just like network break... Please advise

EINSTEIN_007 16-10-2014 11:05 AM

Re: System Time sync Vs SQL
 
There is some problem with the HP Server Model ProLiant BL495c G5 Servers and times issuues with SQL 2005 SP3 in a cluster. The BIOS causes time loss and the only solution is to revert back to an older BIOS for the time being.

tushar.de7 16-10-2014 12:23 PM

Re: System Time sync Vs SQL
 
But here the server if IBM. Shall I disable the Windows Time service from the Services.msc??

tushar.de7 16-10-2014 12:25 PM

Re: System Time sync Vs SQL
 
SQL Express 2008 R2 we are using

EINSTEIN_007 17-10-2014 11:33 AM

Re: System Time sync Vs SQL
 
Yes, you can try to disable the Windows Time service by going to services.msc and see if that works for you.

tushar.de7 17-10-2014 12:53 PM

Re: System Time sync Vs SQL
 
Yes Einstein, I also tried disabling the service but, still the System Time Sync is running and hampering the SQL based application.


All times are GMT +5.5. The time now is 01:31 PM.