Karthick PK 's Blog - All Comments

Interesting Finds: March 17, 2013

Jason Haley — Sun, 17 Mar 2013 11:44:25 GMT

Interesting Finds: March 17, 2013

re: Non-yielding IOCP Listener, Non-yielding Scheduler and non-yielding resource monitor known issues and fixes

Karthick P.K - karthick krishnamurthy — Thu, 13 Dec 2012 07:24:01 GMT

Patz,

Check your disk performance. SQL Server is trying to print "i/o requests taking longer than 15 seconds to complete on file" toerrolog file and there is delay writting to errolog file as well. Fix the disk performance You can follow the steps in below blog.

mssqlwiki.com/.../io-requests-taking-longer-than-15-seconds-to-complete-on-file

re: Non-yielding IOCP Listener, Non-yielding Scheduler and non-yielding resource monitor known issues and fixes

Patz — Thu, 13 Dec 2012 04:21:21 GMT

I got the following output when i'm done with step 6.

sqlservr!CErrorReportingManager::WriteToErrLog

sqlservr!CErrorReportingManager::SendErrorToErrLog

sqlservr!CErrorReportingManager::CwchFormatAndPrint

sqlservr!scierrlog

sqlservr!FCB::ReportLongIO

sqlservr!IoRequestDispenser::CheckForLongIo

sqlservr!BPool::LazyWriter

sqlservr!lazywriter

sqlservr!SOS_Task::Param::Execute

sqlservr!SOS_Scheduler::RunTask

sqlservr!SOS_Scheduler::ProcessTasks

sqlservr!SchedulerManager::WorkerEntryPoint

sqlservr!SystemThread::RunWorker

sqlservr!SystemThreadDispatcher::ProcessWorker

sqlservr!SchedulerManager::ThreadEntryPoint

msvcr80!endthreadex

kernel32!BaseThreadInitThunk

ntdll!RtlUserThreadStart

Can you please help me with this?

re: The process cannot access the file 'C:\Windows\system32\perf-MSSQL10_50.MSSQLSERVER-sqlagtctr.dll' because it is being used by another process.

Carm Vecchio — Fri, 09 Nov 2012 15:21:22 GMT

Thank you for the manual work-around, Are there any intentions to fix the patch so manual intervention is not required? We use automated patching software in designated overnight outage windows. Unles I am missing something, this means a DBA will have to touch every SQL2008R2 SQL Server and MANUALLY rename the files, reboot the server and rerun the patch. Clearly this is unacceptable. Please respond.

re: SQL Agent MaxWorkerThreads and Agent subsystem

Arvindh K — Fri, 21 Sep 2012 11:05:59 GMT

Excellent post

re: Installation of SQLserver2008 cluster fails on windows2008.(The group or resource is not in the correct state to perform the requested operation. (Exception from HRESULT: 0x8007139F)

Karthick P.K - karthick krishnamurthy — Sat, 01 Sep 2012 14:07:13 GMT

Hello Prashanth,

check if you are hitting support.microsoft.com/.../828861

To get faster response join our Facebook group www.facebook.com/mssqlwiki and post your questions.

Thanks

Karthick

re: Installation of SQLserver2008 cluster fails on windows2008.(The group or resource is not in the correct state to perform the requested operation. (Exception from HRESULT: 0x8007139F)

prashanth — Sat, 01 Sep 2012 08:07:01 GMT

I have followed the same-successful on node1, but it threw a different error for me when i tried to add node. During add node setup rule is failing with MSCS Cluster verification error[Cluster report is successful with some warnings]. tried "Setup /SkipRules=Cluster_VerifyForErrors /Action=AddNode", But it did throw into some other error, where the password is not valid though after providing a valid one. can you please comment on this.

re: Non-yielding IOCP Listener, Non-yielding Scheduler and non-yielding resource monitor known issues and fixes

Prashant Jha — Thu, 23 Aug 2012 05:50:46 GMT

Nice compilation! Good job, Karthick :)

re: Non-yielding IOCP Listener, Non-yielding Scheduler and non-yielding resource monitor known issues and fixes

Karthick P.K - karthick krishnamurthy — Wed, 22 Aug 2012 14:37:33 GMT

My bad i missed .cxr try below command

.cxr sqlserver!g_copiedStackInfo+0×20

re: Non-yielding IOCP Listener, Non-yielding Scheduler and non-yielding resource monitor known issues and fixes

Alex — Wed, 22 Aug 2012 14:23:57 GMT

I'm getting ^ Extra character error in 'sqlserver!g_copiedStackInfo+0×20'