SQL Debugging

时间:2021-08-11 17:09:26
C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn>“C:\Program Files\Debugging Tools for Windows (x64)\symchk” sqlservr.exe /s SRV*c:\symbols*http://msdl.microsoft.com/download/symbols

 0 e 000007fe`eb8cb2f0     0001 (0001)  0:**** sqldk!SOS_Task::Param::Init
1 e 000007fe`ec6d64f0 0001 (0001) 0:**** sqlmin!SOS_Task::Param::Init
2 e 000007fe`ed2ab920 0001 (0001) 0:**** sqlmin!ILockBytesDQProxy::WriteAt
3 e 000007fe`ef1efac0 0001 (0001) 0:**** sqlmin!BPool::AllocBuf sqldk!SOS_OS::EnqueueTask
sqldk!SOS_Scheduler::RunTask
sqlmin!BackupLogReader::BackupVLogFile = <no type information>
sqllang!kill_session
sqllang!OptimizerUtil
sqlmin!DBMgr::CreateStreamLogFiles
sqlmin!DumpLogFile::FileWrite
sqlmin!DumpLogFile::BeginRecordOutput
sqlmin!RecoveryMgr::RedoLogFileHeaderModify
sqlmin!RowLog::IsLogFileHeaderUpdate
sqlmin!StreamFileMgr::LogFileCreation
sqlmin!StreamFileMgr::FindLogFile
sqlmin!SQLServerLogMgr::CommitLogFileOp
sqlmin!StreamFileMgr::FindDataFileIdForLogFile
sqlmin!SQLServerLogMgr::RedoLogFileHeaderModify
sqlmin!SQLServerLogMgr::FormatLogFile
sqlmin!SQLServerLogMgr::RollbackLogFileOp
sqlmin!SQLServerLogMgr::DiscoverVirtualLogFiles
sqlmin!SQLServerCOWLogMgr::RollbackLogFileOp
sqlmin!RecoveryMgr::GetLogReadAhead sqlmin!DirtyPageTable::GetMinRecoveryLsn
sqlmin!DirtyPageMgr::GetOldestDirtyLSN
sqlmin!SQLServerLogMgr::LogFlush
sqlmin!SQLServerLogMgr::GetEndWrittenLog
sqlmin!SQLServerLogMgr::GetEndOfLog
sqlmin!SQLServerLogMgr::StartLogFlush
sqlmin!SQLServerLogMgr::StartLogWrite
sqlmin!Page::SetLsn sqlmin!DumpLog::GetStartingLSNFromCkpt
sqlmin!LsMgr::GetNextRedoLsn
sqlmin!LsMgr::AddPastLSN
sqlmin!HaDrUndoMgr::RecordUndoLSN
sqlmin!HaDrDbMgr::GetNextRedoLsn
sqlmin!HadrLocalExtendedRecoveryForkStack::GetRecoveryLsnFromMetadata
sqlmin!HaDrDbMgr::GetDbStartOfLogLsnAndEndOfLogLsn
sqlmin!HadrDbMgrTruncationMgr::PersistTruncationLsnInBootPage
sqlmin!HaDrUndoMgr::UndoToLSN
sqlmin!LSN::AdjustForNextLSN 00000000`1426f030 000007fe`ec80304a sqlmin!TaskReqPktBase::Submit+0xf8
00000000`1426f080 000007fe`ec5fd53b sqlmin!TaskReqPktTimer::CheckTimeoutAndSubmit+0xee
00000000`1426f0b0 000007fe`eb88fe57 sqlmin!CTimerTask::Execute+0xf7
00000000`1426f110 000007fe`eb88f750 sqldk!SOS_Scheduler::SystemTimerEntryPoint+0x132
00000000`1426f190 000007fe`eb88f534 sqldk!SOS_Task::Param::Execute+0x21e
00000000`1426f790 000007fe`eb88f336 sqldk!SOS_Scheduler::RunTask+0xa8
00000000`1426f800 000007fe`eb8c9bcf sqldk!SOS_Scheduler::ProcessTasks+0x279
00000000`1426f880 000007fe`eb8ca3a0 sqldk!SchedulerManager::WorkerEntryPoint+0x24c
00000000`1426f920 000007fe`eb8ca266 sqldk!SystemThread::RunWorker+0x8f
00000000`1426f950 000007fe`eb8cab48 sqldk!SystemThreadDispatcher::ProcessWorker+0x3ab
00000000`1426fa00 00000000`76be652d sqldk!SchedulerManager::ThreadEntryPoint+0x226
00000000`1426faa0 00000000`76d1c521 kernel32!BaseThreadInitThunk+0xd
00000000`1426fad0 00000000`00000000 ntdll!RtlUserThreadStart+0x1d 00000000`161bd5f8 000007fe`e0404a19 sqlmin!SQLServerLogMgr::LogFlush
00000000`161bd600 000007fe`e03ffd5b sqlmin!logCkptXactInfo+0x2f9
00000000`161bdb90 000007fe`e046293c sqlmin!HardenAndLogCheckpoint+0x9cf
00000000`161be560 000007fe`e046283a sqlmin!CheckpointRU2+0x27b
00000000`161be5e0 000007fe`e0462772 sqlmin!AsynchronousDiskAction::DoFlushCache+0x98
00000000`161be610 000007fe`e04625e1 sqlmin!AsynchronousDiskAction::ExecuteDeferredAction+0x246
00000000`161be6c0 000007fe`e03e5972 sqlmin!AsynchronousDiskWorker::ThreadRoutine+0x15c
00000000`161be790 000007fe`f33cf750 sqlmin!SubprocEntrypoint+0xa82
00000000`161bf4c0 000007fe`f33cf534 sqldk!SOS_Task::Param::Execute+0x21e
00000000`161bfac0 000007fe`f33cf336 sqldk!SOS_Scheduler::RunTask+0xa8
00000000`161bfb30 000007fe`f3409bcf sqldk!SOS_Scheduler::ProcessTasks+0x279
00000000`161bfbb0 000007fe`f340a3a0 sqldk!SchedulerManager::WorkerEntryPoint+0x24c
00000000`161bfc50 000007fe`f340a266 sqldk!SystemThread::RunWorker+0x8f
00000000`161bfc80 000007fe`f340ab48 sqldk!SystemThreadDispatcher::ProcessWorker+0x3ab
00000000`161bfd30 00000000`76be652d sqldk!SchedulerManager::ThreadEntryPoint+0x226
00000000`161bfdd0 00000000`76d1c521 kernel32!BaseThreadInitThunk+0xd
00000000`161bfe00 00000000`00000000 ntdll!RtlUserThreadStart+0x1d sqllang!OptimizerUtil
00000000`103ff2d8 000007fe`f33cf750 sqllang!kill_session
00000000`103ff2e0 000007fe`f33cf534 sqldk!SOS_Task::Param::Execute+0x21e
00000000`103ff8e0 000007fe`f33cf336 sqldk!SOS_Scheduler::RunTask+0xa8
00000000`103ff950 000007fe`f3409bcf sqldk!SOS_Scheduler::ProcessTasks+0x279
00000000`103ff9d0 000007fe`f340a3a0 sqldk!SchedulerManager::WorkerEntryPoint+0x24c
00000000`103ffa70 000007fe`f340a266 sqldk!SystemThread::RunWorker+0x8f
00000000`103ffaa0 000007fe`f340ab48 sqldk!SystemThreadDispatcher::ProcessWorker+0x3ab
00000000`103ffb50 00000000`76be652d sqldk!SchedulerManager::ThreadEntryPoint+0x226
00000000`103ffbf0 00000000`76d1c521 kernel32!BaseThreadInitThunk+0xd
00000000`103ffc20 00000000`00000000 ntdll!RtlUserThreadStart+0x1d sqllang!ExcHandler::ExcHandler: 00000000`1572e460 000007fe`edffe047 sqllang!process_request+0xa8a
00000000`1572ec00 000007fe`f33cf750 sqllang!process_commands+0x4a3
00000000`1572ef20 000007fe`f33cf534 sqldk!SOS_Task::Param::Execute+0x21e
00000000`1572f520 000007fe`f33cf336 sqldk!SOS_Scheduler::RunTask+0xa8
00000000`1572f590 000007fe`f3409bcf sqldk!SOS_Scheduler::ProcessTasks+0x279
00000000`1572f610 000007fe`f340a3a0 sqldk!SchedulerManager::WorkerEntryPoint+0x24c
00000000`1572f6b0 000007fe`f340a266 sqldk!SystemThread::RunWorker+0x8f
00000000`1572f6e0 000007fe`f340ab48 sqldk!SystemThreadDispatcher::ProcessWorker+0x3ab
00000000`1572f790 00000000`76be652d sqldk!SchedulerManager::ThreadEntryPoint+0x226
00000000`1572f830 00000000`76d1c521 kernel32!BaseThreadInitThunk+0xd
00000000`1572f860 00000000`00000000 ntdll!RtlUserThreadStart+0x1d Child-SP RetAddr Call Site
00000000`0712cd40 000007fe`ecedb17e sqlmin!ChecksumSectors+0x8f
00000000`0712cd50 000007fe`eced1014 sqlmin!LC::StuffEncryptAndChecksum+0x293
00000000`0712ce50 000007fe`eced13ee sqlmin!SQLServerLogMgr::FormatLC+0x161
00000000`0712cec0 000007fe`ece25bc6 sqlmin!SQLServerLogMgr::FlushLC+0x50f
00000000`0712d470 000007fe`f624f750 sqlmin!SQLServerLogMgr::LogWriter+0xd28
00000000`0712f260 000007fe`f624f534 sqldk!SOS_Task::Param::Execute+0x21e
00000000`0712f860 000007fe`f624f336 sqldk!SOS_Scheduler::RunTask+0xa8
00000000`0712f8d0 000007fe`f6289bcf sqldk!SOS_Scheduler::ProcessTasks+0x279
00000000`0712f950 000007fe`f628a3a0 sqldk!SchedulerManager::WorkerEntryPoint+0x24c
00000000`0712f9f0 000007fe`f628a266 sqldk!SystemThread::RunWorker+0x8f
00000000`0712fa20 000007fe`f628ab48 sqldk!SystemThreadDispatcher::ProcessWorker+0x3ab
00000000`0712fad0 00000000`772b652d sqldk!SchedulerManager::ThreadEntryPoint+0x226
00000000`0712fb70 00000000`774ec521 kernel32!BaseThreadInitThunk+0xd
00000000`0712fba0 00000000`00000000 ntdll!RtlUserThreadStart+0x1d SELECT TOP 11 *
FROM fn_dump_dblog( DEFAULT, DEFAULT,DEFAULT, DEFAULT, 'C:\Upside db\UPSIDE60_GOLD_backup_2013_01_03_000004_9568891.bak', DEFAULT,DEFAULT,
DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT,
DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT,
DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT,DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT,
DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT,
DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT,
DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT ) AS LogRecords s-u 0x00000000 L?0x7fffffff 9568891
ba r4 00000000`0271c898
00000000`0271c898 00000000`772b0643 ntdll!memset+0x9e
00000000`0271c8a0 000007fe`e333717b kernel32!GetVolumePathNameInternalW+0xd3
00000000`0271c980 000007fe`e37094f8 sqlmin!FCB::GetActualSectorSize+0x1eb
00000000`0271d310 000007fe`e3708ec7 sqlmin!BackupDiskFile::GetMediaCharacteristics+0x68
00000000`0271d5b0 000007fe`e37df48f sqlmin!BackupDiskFile::OpenMedia+0x67
00000000`0271e690 000007fe`e372f842 sqlmin!BackupMediaIo::Open+0x3f
00000000`0271e700 000007fe`e3757be0 sqlmin!BackupMedium::Open+0x32
00000000`0271e730 000007fe`e37607c1 sqlmin!BackupStream::ThreadMainRoutine+0x180
00000000`0271e7e0 000007fe`e07e5972 sqlmin!BackupThread::ThreadBase+0x51
00000000`0271e880 000007fe`f5f5f750 sqlmin!SubprocEntrypoint+0xa82
00000000`0271f5b0 000007fe`f5f5f534 sqldk!SOS_Task::Param::Execute+0x21e
00000000`0271fbb0 000007fe`f5f5f336 sqldk!SOS_Scheduler::RunTask+0xa8
00000000`0271fc20 000007fe`f5f99bcf sqldk!SOS_Scheduler::ProcessTasks+0x279
00000000`0271fca0 000007fe`f5f9a3a0 sqldk!SchedulerManager::WorkerEntryPoint+0x24c
00000000`0271fd40 000007fe`f5f9a266 sqldk!SystemThread::RunWorker+0x8f
00000000`0271fd70 000007fe`f5f9ab48 sqldk!SystemThreadDispatcher::ProcessWorker+0x3ab
00000000`0271fe20 00000000`772b652d sqldk!SchedulerManager::ThreadEntryPoint+0x226
00000000`0271fec0 00000000`774ec521 kernel32!BaseThreadInitThunk+0xd
00000000`0271fef0 00000000`00000000 ntdll!RtlUserThreadStart+0x1d 00000000`15ffc450 000007fe`fd405996 ntdll!RtlGetFullPathName_UEx+0x39
00000000`15ffc4a0 00000000`772b05e3 KERNELBASE!GetFullPathNameW+0x16
00000000`15ffc4e0 000007fe`e333717b kernel32!GetVolumePathNameInternalW+0x73
00000000`15ffc5c0 000007fe`e37094f8 sqlmin!FCB::GetActualSectorSize+0x1eb
00000000`15ffcf50 000007fe`e3708ec7 sqlmin!BackupDiskFile::GetMediaCharacteristics+0x68
00000000`15ffd1f0 000007fe`e37df48f sqlmin!BackupDiskFile::OpenMedia+0x67
00000000`15ffe2d0 000007fe`e372f842 sqlmin!BackupMediaIo::Open+0x3f
00000000`15ffe340 000007fe`e3757be0 sqlmin!BackupMedium::Open+0x32
00000000`15ffe370 000007fe`e37607c1 sqlmin!BackupStream::ThreadMainRoutine+0x180
00000000`15ffe420 000007fe`e07e5972 sqlmin!BackupThread::ThreadBase+0x51
00000000`15ffe4c0 000007fe`f609f750 sqlmin!SubprocEntrypoint+0xa82
00000000`15fff1f0 000007fe`f609f534 sqldk!SOS_Task::Param::Execute+0x21e
00000000`15fff7f0 000007fe`f609f336 sqldk!SOS_Scheduler::RunTask+0xa8
00000000`15fff860 000007fe`f60d9bcf sqldk!SOS_Scheduler::ProcessTasks+0x279
00000000`15fff8e0 000007fe`f60da3a0 sqldk!SchedulerManager::WorkerEntryPoint+0x24c
00000000`15fff980 000007fe`f60da266 sqldk!SystemThread::RunWorker+0x8f
00000000`15fff9b0 000007fe`f60dab48 sqldk!SystemThreadDispatcher::ProcessWorker+0x3ab
00000000`15fffa60 00000000`772b652d sqldk!SchedulerManager::ThreadEntryPoint+0x226
00000000`15fffb00 00000000`774ec521 kernel32!BaseThreadInitThunk+0xd
00000000`15fffb30 00000000`00000000 ntdll!RtlUserThreadStart+0x1d

SQL Debugging的更多相关文章

  1. Microsoft SQL Server Version List &lbrack;sqlserver 7&period;0-------sql server 2016&rsqb;

    http://sqlserverbuilds.blogspot.jp/   What version of SQL Server do I have? This unofficial build ch ...

  2. Microsoft SQL Server Version List(SQL Server 版本)

    原帖地址 What version of SQL Server do I have? This unofficial build chart lists all of the known Servic ...

  3. 连接池和 &quot&semi;Timeout expired&quot&semi;异常

    转自:博客园宁静.致远:http://www.cnblogs.com/zhangzhu/archive/2013/10/10/3361197.html 异常信息: MySql.Data.MySqlCl ...

  4. 连接池和 &quot&semi;Timeout expired&quot&semi;异常【转】

    异常信息: MySql.Data.MySqlClient.MySqlException (0x80004005): error connecting: Timeout expired. The tim ...

  5. ODAC 下载

    官网地址: https://www.oracle.com/technetwork/topics/dotnet/downloads/odacdev-4242174.html 官方说说明: ODAC 18 ...

  6. 【C&num;】Visual Studio 2017 一边Debug,一边修改代码

    好久没写C#了,最近在学习著名***工具 *-windows 的源代码,想着可以边断点调试,边加上一些注释以方便理解,* 和 msdn 随便翻了一下,竟发现 ...

  7. Oracle DBA神器之Toad

    很早就听说Toad功能很强大,一直没有使用过,因为PLSQL Developer就很好用.前几天看见同事优化Oracle就是用的Toad,有一些很强大的管理功能,于是再一次对Toad产生兴趣,收集了一 ...

  8. SqlServer 版本号

    RTM (no SP) SP1 SP2 SP3 SP4 SQL Server 2014      codename Hekaton  12.00.2000.8 SQL Server 2012      ...

  9. 无法Debug SQL&colon; Unable to start T-SQL Debugging&period; Could not attach to SQL Server process on

    今天SSMS debug SQL当脚本,突然错误: Unable to start T-SQL Debugging. Could not attach to SQL Server process on ...

随机推荐

  1. BZOJ2934 &colon; &lbrack;Poi1999&rsqb;祭坛问题

    对于每个祭坛,算出每条线段阻碍它的角度区间,然后排序求并看看是否有空位即可,时间复杂度$O(n^2\log n)$. 这题在Main上官方时限是0.2S,因此需要几个常数优化: $1.$为了避免用at ...

  2. 关于struts2上传图片临时文件

  3. Spring AOP 切面编程的方法

    spring aop的使用分为两种,一种是使用注解来实现,一种是使用配置文件来实现. 先来简单的介绍一下这两种方法的实现,接下来详细的介绍各处的知识点便于查阅.目录如下: 1.基于注解实现spring ...

  4. mysql 修改数据库data存放位置

    一.首先把mysql的服务先停掉. 二.更改MySQL配置文件My.ini中的数据库存储主路径 打开MySQL默认的安装文件夹C:\Program Files\MySQL\MySQL Server 5 ...

  5. 项目实战11—企业级nosql数据库应用与实战-redis的主从和集群

    企业级nosql数据库应用与实战-redis 环境背景:随着互联网2.0时代的发展,越来越多的公司更加注重用户体验和互动,这些公司的平台上会出现越来越多方便用户操作和选择的新功能,如优惠券发放.抢红包 ...

  6. (转)热空气扭曲效果shader

    转自:http://blog.sina.com.cn/s/blog_89d90b7c0102vaqy.html 热空气扭曲在大自然中形成是比较复杂的,这里只是通过取屏幕纹理和移动UV来模拟热扭曲效果. ...

  7. java ASM动态生成类

    BeanTest2.java import java.io.FileOutputStream; import org.objectweb.asm.AnnotationVisitor; import o ...

  8. Java基础90 MySQL触发器

    1.创建触发器 CREATE TRIGGER trigger_name trigger_time trigger_event ON tbl_name FOR EACH ROW trigger_stmt ...

  9. spring boot 开发 提交form表单出错

    提交表单时,字段有的没有值,springboot 会报错. org.springframework.validation.BindException: org.springframework.vali ...

  10. laravel跨域问题

    // 只有同源策略才允许发送cookies // header('Access-Control-Allow-Credentials:true'); 需要要index.php下开启 最近写登录图形验证码 ...