SQL Server Blogs
- Max server memory – Do I need to configure?
- SQL Server and VMware ballooning
- Inside sys.dm_os_ring_buffers
- SQL Server lock pages in memory
- SQL Server -g
- SQL Server Operating system (SOS) – Series 3
- SQL Server Operating system (SOS) – Series 2
- SQL Server Operating system (SOS) – Series 1
- SQL Server fails to start with error "Failed allocate pages: FAIL_PAGE_ALLOCATION 1" During startup
- Debugging memory Leaks using Debug diagnostic tool.
- SQL Server memory leak
- SQL Server NUMA load distribution
- Query optimization
- SQL Server 2012 Memory
- SQL Server Exception , EXCEPTION_ACCESS_VIOLATION and SQL Server Assertion
- What is RESOURCE_SEMAPHORE_QUERY_COMPILE?
- SQL Server Parameter sniffing
- Optimizer Timeout or Optimizer memory abort
- Troubleshooting SQL Server high CPU usage
- SQL Server Latch & Debugging latch time out
- SQL Server: Ghost records
- I/O requests taking longer than 15 seconds to complete on file
- Database Mail errors in SQL Server (Troubleshooting steps)
- Non-yielding IOCP Listener, Non-yielding Scheduler and non-yielding resource monitor known issues and fixes
- How to analyze Non-Yielding scheduler or Non-yielding IOCP Listener dumps ……
- SQL Server generated Access Violation dumps while accessing oracle linked servers.
- Service pack ,Hotfix and CU installation for SQL Server 2005 might fail with “Unable to install Windows Installer MSI file“
- A significant part of SQL Server process memory has been paged out
- What is Target Server Memory (KB)?
- SQL Server performance degraded in 32-Bit SQL Server after adding additional RAM.
- Transaction log for the database is growing and system SPID is holding open transaction
- Copy database wizard or replication setup might fail due to broken dependency
- SQL Server Agent is taking long time to start
- (SQLServer) Initializing the FallBack certificate failed with error code: 1, state: 1, error number: -2146893802.
- Multi Threaded OVELAPPED and Nonbuffered I/O Example
- Asynchronous I/O example
- SQL-Server resource fails to come online IS Alive check fails
- The backup of the file or filegroup "" is not permitted because it is not online. BACKUP can be performed by using the FILEGROUP or FILE clauses to restrict the selection to include only online data.
- How to move the LOB data from one file group to other?
- Linked server connection fails with “An error occurred during decryption”
- SQL Saturday #116 : Don’t miss it
- How to Create process in c++….. CreateProcess function
- My “c:\” Drive gets full when I open the profiler trace
- System stored procedures like sp_addsrvrolemember or sp_addserver may fail because of McAfee Host Intrusion Prevention
- how to Open CreateFile (Createfile example)
- Beyond XP_READERRORLOG (Parameters of XP_READERRORLOG)
- A failure was detected for a previous installation, patch, or repair during configuration for features [SQL_PowerShell_Engine_CNS,SQL_PowerShell_Tools_ANS]. In order to apply this patch package (KB968369), you must resolve any issues with the previous operation that failed.
- How to get the current state of cluster resource?
- Script to free cache
- QueryMemoryResourceNotification & CreateMemoryResourceNotification (How SQL Server identifies low system memory on the system and respond to low system memory?)
- How to find SQL Server and system CPU usage history :
- The database ‘model’ is marked RESTORING and is in a state that does not allow recovery to be run.Could not create tempdb. You may not have enough disk space available. Free additional disk space by deleting other files on the tempdb drive
- Script to get current blocking tree with wait types
- SQL Server2008/SQL Server2012: Script level upgrade for database ‘master’ failed because upgrade step ‘sqlagent100_msdb_upgrade.sql’ encountered error 574, state 0, severity 16
- AWE allocator API’s (How SQL Server AWE works)
- SQLServer 2008 Fails to come online on cluster after upgrade
- How to rebuild index and update statistics for all the tables in database.
- I get error while I update a row in immediate updating subscription what is the cause?
- Tasks and connection icons missing after importing DTS in SQL Server management studio
- Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created
- Runtime error: ActiveX component can’t create object: ‘SQLDMO.SQLServer’
- How to check if local system is connected to a network and identify the type of network connection
- I get Exception when i open SQL Server management studio
- How to check if my account has LPM privilege
- Using DMVs to find out the index usage history- SQL Server Index Usage
- I cant not backup my database from SSMS….
- We do not see the SQL server and SQL Agent status from management studio. When we right click the instance, start, stop and resume options is disabled.
- How to Analyze "Deadlocked Schedulers" Dumps?
- Configuring SSL for SQL Server using Microsoft Certificate Authority Server
- How to retrieve information about the file system and volume associated with the specified root directory (GetVolumeInformation function)
- “Value cannot be null” when i connect SQL Server from SSMS
- How to find all the profiler traces running on my SQL Server
- DBCC CheckDB fails with error "The database could not be checked as a database snapshot could not be created and the database or table could not be locked
- How to get SQL Text and Query Plan for statements which are executing now
- Script to clear stats
- How to monitor the Session and query which Consumes Tempdb
- Trivial Plan
- How to add an IP Address when we Add new NIC to node where SQLServer2005 instance is running.
- Different Status bits of sysdatabases in SQLServer
- Installation of SQLServer2008 fails (The registry key SYSTEM\CurrentControlSet\Services\RsFx0102\InstancesShares is missing)
- 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)
- Installation of SQLServer2005/2008 Fails on Windows2008 Cluster.
- Using DMVs to find out the index usage history- SQLServer Index Usage
- Script to get all the Query and cached plans
- How to find who altered my SQL Server Login
- How to Browse (or) view objects and there code in mssqlsystemresource Database
- Queries with table variables are slow in SQL2005 compared with SQL2000 (Table Variables (VS) Temp Tables)
- Behavior of SQL Server default instance on a NON-Default port
- Unable to start SQLServer agent resource on cluster after upgrading to 9.00.3186 or Higher
- How to enable Constraint delegation for SQLServer2005
Good SQL Server Blogs - Brad Chen's SQL Server Blog - Site Home - MSDN Blogs said
[…] Karthick P.K SQL Server Blogshttps://mssqlwiki.com/sqlblogs/ […]
How To Fix 0x8007139f Sql Errors - Windows Vista, Windows 7 & 8 said
[…] SQL Server Blogs « MSSQLWIKI – Max server memory – Do I need to configure? SQL Server and VMware ballooning Inside sys.dm_os_ring_buffers SQL Server lock pages in memory SQL Server -g SQL Server …… […]
How To Fix Exception From Hresult 0x8007139f Errors - Windows Vista, Windows 7 & 8 said
[…] SQL Server Blogs « MSSQLWIKI – Max server memory – Do I need to configure? SQL Server and VMware ballooning Inside sys.dm_os_ring_buffers SQL Server lock pages in memory SQL Server -g SQL Server …… […]
thiet bi cong nghe said
Major advancements in technology are leading to
a wealth of consumer technologies, but in some ways, it’s the increasing use of these
high-tech products that is making safety technology in vehicles
more necessary than ever. And now the technology has brought latest
world news in your drawing room. It’s absolutely a sleek eye-catcher, yet is there anything
to the claim.
Khun Hla Maung said
how to resolve this error message “OS Error: Terminating system thread due to exceptionn in processworker” in SQL Server 2016 Standard Edition.