- 博客(57)
- 收藏
- 关注
转载 SQL Service can not be restarted due to errors of upgrade step
Errors:Script level upgrade for database 'master' failed because upgrade step 'sqlagent100_msdb_upgrade.sql' encountered error 5833, state 1, severity 16. This is a serious error condition whic...
2018-12-10 14:51:00
228
转载 SQL Server-errors for exceptions, assertions, and hang conditions
From:https://support.microsoft.com/en-us/help/2028589/sql-server-reports-errors-for-exceptions-assertions-and-hang-conditionSymptomsSQL Server records the following events in th...
2018-09-12 14:39:00
238
转载 SQL Server-The target principal name is incorrect. Cannot generate SSPI context
From:https://blogs.msdn.microsoft.com/meer_alam/2015/05/10/the-target-principal-name-is-incorrect-cannot-generate-sspi-context/Introducing the problem scenarioYet another Kerberos authentic...
2018-08-23 15:37:00
651
转载 SQL Server-Restore master DB
转载于:https://www.cnblogs.com/roseHLF/p/9436536.html
2018-08-07 13:41:00
116
转载 SQL installation-VS Shell installation has failed with exit code 5
Background:During the installation of SQL 2016 STD,there has one error raised,checked the log of installation,found below errors: TITLE: Microsoft SQL Server 2016 Setup---------------------...
2018-08-06 13:22:00
293
转载 Stop and delete trace session
转载于:https://www.cnblogs.com/roseHLF/p/9406333.html
2018-08-02 11:56:00
85
转载 SQL-replication errors,could not find stored procedure
Refer tohttps://www.mssqltips.com/sqlservertip/5107/resolve-sql-server-replication-error--could-not-find-stored-procedure-spmsupddbops/Refer tohttps://docs.microsoft.com/en-us/sql/relational-...
2018-07-26 17:11:00
277
转载 数据库空间管理-学习笔记
来自《SQL Server 2012实施与管理实战指南》1.数据文件的存储结构:页:数据存储的基本单位是页,每一个页为8kb,每MB有128页。磁盘的IO操作在页级。每页开头是一个96字节的页头,用于存储页的系统信息,包括页码、页类型、页的可用空间,以及拥有该页的对象的分配单元ID。不同类型的数据存储在不同类型的页面里面。(1) GAM(Global allocation m...
2018-07-19 17:22:00
100
转载 SQL I/O操作学习笔记
SQL Server在以下情况需要和硬盘进行交互:1.对于内存当中没有缓存的数据,第一次访问时需要将数据所在的页面从数据文件中读取到内存里。读取时以页面为最小单位。出于性能考虑,读取的数据可能不仅仅包含所请求的内存页,同时还包含了预读的内存页。读取的数量与用户需要需要访问和数据页面数量和buffer pool里面现有缓存的数量有关系。2.在任何Insert\Update\De...
2018-07-13 14:41:00
145
转载 The process is running and is waiting for response from the server
Refer tohttp://sqlservercitation.com/2017/03/28/fix-replication-process-is-running-and-waiting-for-a-response-from-the-server/For this case,sometimes it may caused by anyblocking processthat...
2018-07-12 15:42:00
332
转载 Operating system error 995(The I/O operation has been aborted because of either a thread)
Fromhttps://technet.microsoft.com/en-us/library/aa337272.aspxMSSQLSERVER_3271Other VersionsTopic Status:Some information in this topic is preview and subject to change i...
2018-07-12 14:35:00
1428
转载 Grant permissions to multiple tables in a database
USE DBGO DECLARE @TableName AS varchar(max)DECLARE @Script AS varchar(max) DECLARE CurGrant CURSOR FORSELECT nameFROM sys.tables WHERE name LIKE '%Sales_%'OPEN CurGrantFETCH NEXT FROM CurG...
2018-06-28 10:42:00
75
转载 MSDB Database
From:https://docs.microsoft.com/en-us/sql/relational-databases/databases/msdb-database?view=sql-server-2017Themsdbdatabase is used by SQL Server Agent for scheduling alerts and jobs and by ot...
2018-06-27 10:30:00
109
转载 Change Instance\database collation
Reference from below links:http://www.itprotoday.com/microsoft-sql-server/seven-step-process-changing-databases-collationhttps://www.mssqltips.com/sqlservertip/3519/changing-sql-server-collat...
2018-06-26 17:27:00
181
转载 Upgrading a Replication Topology to SQL Server 2016
From link :https://blogs.msdn.microsoft.com/sql_server_team/upgrading-a-replication-topology-to-sql-server-2016/SQL Server Replication provides multi-faceted data movement capabilities a...
2018-06-07 10:12:00
115
转载 SQL Profile trace run access grant
From:https://www.mssqltips.com/sqlservertip/3559/how-to-grant-permissions-to-run-sql-server-profiler-for-a-non-system-admin-user/Steps to give access to run SQL Server Profiler for a non sa use...
2018-05-23 11:50:00
87
转载 Log Reuse Waits Explained: DATABASE_MIRRORING
From:http://sqlity.net/en/1843/log-reuse-waits-explained-database_mirroring/IntroductionThere are eight reasons SQL Server might report when it cannot truncate the transaction log. Any one of...
2018-05-16 15:04:00
123
转载 Log Reuse Waits Explained: ACTIVE_TRANSACTION
From:http://sqlity.net/en/1839/log-reuse-waits-explained-active_transaction/IntroductionThere are eight reasons SQL Server might report when it cannot truncate the transaction log. Any one ...
2018-05-16 15:02:00
158
转载 Log Reuse Waits Explained: LOG_BACKUP
From:http://sqlity.net/en/1830/log-reuse-waits-explained-log_backup/IntroductionThere are eight reasons SQL Server might report when it cannot truncate the transaction log. Any one of these r...
2018-05-16 15:00:00
133
转载 Log Reuse Waits Explained: ACTIVE_BACKUP_OR_RESTORE
From:http://sqlity.net/en/1835/log-reuse-waits-explained-active_backup_or_restore/IntroductionThere are eight reasons SQL Server might report when it cannot truncate the transaction log. Any ...
2018-05-16 15:00:00
234
转载 Log Reuse Waits Explained: CHECKPOINT
From:http://sqlity.net/en/1819/log-reuse-waits-explained-checkpoint/IntroductionThere are eight reasons SQL Server might report when it cannot truncate the transaction log. Any one of these r...
2018-05-16 14:59:00
131
转载 Transaction Log Reuse Wait
From link as below:http://sqlity.net/en/556/t-sql-tuesday-25-%E2%80%93-sql-server-tips-tricks/One question that keeps coming up in forums, at user group meetings and on twitter is: Why is my ...
2018-05-16 14:58:00
113
转载 enable non-sysadmin accounts to execute the "xp_cmdshell
Document from :https://support.microsoft.com/en-us/help/890775/how-to-enable-non-sysadmin-accounts-to-execute-the-xp-cmdshell-extendeSummaryThis article describes how to confi...
2018-05-15 10:36:00
162
转载 Restore DB issues
1.The backup set holds a backup of a database other than the existing databasesolution:(1) delete the database which is new created;(2) Right click Databases to restore database(3) chang...
2017-10-17 09:43:00
75
转载 rebuild index and update statistics
Refer tohttp://blog.sina.com.cn/s/blog_630d50dc0102vwwh.html1.UPDATE STATISTICS table with fullscan-->this will update both on index statistics and column statistics2.Update statistics ta...
2017-10-04 15:36:00
188
转载 SQL Server-2012 database query foundation
1 Categories of query statements2 Logical query processing3转载于:https://www.cnblogs.com/roseHLF/p/7399262.html
2017-08-20 11:04:00
62
转载 SQL Server-backup failed due to files is being used by other process
Error messages as below:BackupDiskFile::CreateMedia: Backup device F:\server\instance\Backups\Full\database\DB_full.bak failed to create. Operating system error 32(The process cannot access the...
2017-07-28 16:47:00
141
转载 SQL Server-内存相关配置
(1)服务器的最小最大内存配置(2)AWE Enabled32位OS只能使用2GB的虚拟内存,如果在BOOT.ini文件设置转载于:https://www.cnblogs.com/roseHLF/p/7250393.html
2017-07-28 15:12:00
120
转载 SQL Server-CPU相关配置
(1)关联掩码affinity mask:控制CPU到SQL Server进程的映射。默认情况下,sql server 可以使用服务器上所有可用的处理器。 当一台服务器上有多个应用程序在运行并且windows处于高负荷的情况下时,可能会将线程移动到不用的CPU中。这是可以通过关联掩码,将SQL server的每个调度绑定到各自的CPU中,通过消除线程的迁移,来减轻因为上...
2017-07-28 11:18:00
705
转载 SQL Server-事务日志文件过大的处理方法
概念:1.虚拟日志虚拟日志文件是事务日志文件的截断单位,每个事务日志文件都被逻辑地分成称为虚拟日志文件的较小的段,每个虚拟日志文件的最小大小为256KB,每个事务日志文件的最小大小为512KB,可以提供两个256KB大小的虚拟日志文件。虚拟日志文件的数目和大小会随着事务日志文件的大小的增加。小日志文件可以包含较小量的小虚拟日志文件,大日志文件可以有较大的虚拟日志文件。小虚拟日...
2017-07-28 10:25:00
482
转载 Windows-Active directory活动目录
1.Name space为任何给定名字的解析边界,为这个名字所能提供或关联,映射的所有信息范围。即我们在服务器上通过查找一个对象可以查到的所有关联信息总和。2.对象活动目录的信息实体,即通常的‘属性’,一组属性的集合3.容器名字空间的一部分,与对象一样,也有属性,不同的是,它代表存放对象的空间,比名字空间小4.目录树容器和对象构成的层次结构,表达了对象的连接方...
2017-07-25 14:53:00
94
转载 SQL Server-Resource Monitor worker appears to be non-yielding on Node 0
Refer tohttps://support.microsoft.com/it-it/help/2216485/fix-resource-monitor-enters-a-non-yielding-condition-on-a-server-that?spid=1044&sid=1229%3Fspid%3D1044&sid=1229Cause...
2017-07-21 11:34:00
412
转载 SQL Server-create database failed
Error messages as below:Could not obtain exclusive lock on database 'model'. Retry the operation later.CREATE DATABASE failed. Some file names listed could not be created. Check related error...
2017-07-21 10:47:00
976
转载 SQL Server-查找数据库对象的用户或语句权限
摘自:http://www.yesky.com/imagesnew/software/tsql/ts_sp_help_1rxw.htmsp_helprotect返回一个报表,报表中包含当前数据库中某对象的用户权限或语句权限的信息。语法sp_helprotect[ [@name=]'object_statement'][,[@username=...
2017-07-20 09:35:00
876
转载 SQL Server-更新统计信息
文章出自:https://yq.aliyun.com/articles/67176摘要:1.何时更新统计信息(1)查询执行缓慢,或者查询语句突然执行缓慢。这种场景很可能是由于统计信息没有及时更新而遭遇了参数嗅探的问题。(2)当大量数据更新(INSERT/DELETE/UPDATE)到升序或者降序的列时,这种情况下,统计信息直方图可能没有及时更新。(3)建议在除索引维护...
2017-07-19 16:19:00
141
转载 SQL Server-Drop login
Msg 50000, Level 16, State 127, Line 280Login 'XXX' owns one or more database(s). Change the owner of the database(s) before dropping the login.1.Use below commands to check which database...
2017-07-10 10:39:00
322
转载 SQL Server-性能分析学习笔记
1.性能指标:响应时间、吞吐量、可扩展性(1)响应时间:终端用户的请求尽可能要快速响应;(2)吞吐量:资源的使用情况(网络、设备、端口、虚电路或者其他设备单位时间内传送数据的数量)(3)可扩展性:表示遇到性能问题时,是否可以通过简单的增加资源的方法来解决问题2.根据性能数据分析问题(1)大部分性能问题出现在低效编码以及不合理的设计上面,比如可以先通过查找逻辑读取最高的...
2017-06-30 17:42:00
80
转载 SQL server-Msg 832 error (constant page has changed)
How to troubleshoot Msg 832 (constant page has changed) in SQL ServerFrom:https://support.microsoft.com/en-us/help/2015759/how-to-troubleshoot-msg-832-constant-page-has-changed-in-sql-...
2017-06-19 13:49:00
174
转载 SQL Server-troubleshooting SQL Server I/O requests taking longer than 15 seconds – I/O stalls & Disk...
From:https://blogs.msdn.microsoft.com/sqlsakthi/2011/02/09/troubleshooting-sql-server-io-requests-taking-longer-than-15-seconds-io-stalls-disk-latency/SQL Server has encountered x occurrence...
2017-06-15 11:26:00
308
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人