MSSQLWIKI
Karthick P.K on SQL Server
Karthick P.K
Categories
- Always On
- Backup/Restore
- Configuration
- Connectivity
- Copy database wizard
- Database mail
- DBCC
- Debugging
- DTS/SSIS
- Memory
- Optimizer
- Performance
- Programming
- Recovery
- Replication
- Security
- Space management
- SQL Cluster Setup
- SQL General
- SQL Query
- SQL Saturday
- SQL Server Cluster
- SQL Server Engine
- SQL Server I/O
- SQL Server memory
- SQL Server Setup
- SQL Server Tools
- SQLServer SOS
- SSMS
- Startup failures
- Summary
Archives
- October 2020
- January 2014
- December 2013
- November 2013
- September 2013
- June 2013
- May 2013
- April 2013
- March 2013
- February 2013
- January 2013
- December 2012
- November 2012
- October 2012
- September 2012
- August 2012
- July 2012
- June 2012
- May 2012
- April 2012
- March 2012
- February 2012
- January 2012
- December 2011
- July 2011
- June 2011
- March 2011
- February 2011
- January 2011
- December 2010
- November 2010
- October 2010
- September 2010
- August 2010
- July 2010
- June 2010
- May 2010
- April 2010
- March 2010
- February 2010
- January 2010
- May 2009
- April 2009
- March 2009
- February 2009
- January 2009
Tags
17883 17884 17887 17888 AllocateUserPhysicalPages AWE Allocator API's Blocking Connectivity CreateFile CreateMemoryResourceNotification Debugging Encrytion error 17883 non yielding Error: 15466 External dump process returned no errors External dump process returned no errors.DoMiniDump () encountered error GetClusterResourceState GetPerformanceInfo GetProcessMemoryInfo GetVolumeInformation Index usage Inside SQLOS Level 16 Linked server LockPagesinMemory LookupPrivilegeValue MapUserPhysicalPages max server memory memory dump memory leak non-yielding Non-yielding IOCP Listener Non-yielding Scheduler OpenCluster OpenClusterResource OpenProcess OSVERSIONINFOEX Overlapped I/O OVERLAPPED structure Performance Process 0:0:0 ( ) Worker appears to be non-yielding on Scheduler Profiler QueryMemoryResourceNotification Query tuning Replication Severity: 16 SOS SQL General SQLOS SQL Query sql scheduler SQL Server 2005 SQL Server 2008 SQLServer Cluster SQLServer CPU SQLServer dump SQL Server management studio sql server maximum server memory SQLServer mdmp SQL Server memory sqlserver memory SQLServer operating system sql server performance SQLServer scheduler SQLServer SOS SQLServer Tools SSMS Stack Dump State: 1. Trace Transactional replication UMS User mode sceduler VirtualAlloc What is SQLSOS?Facebook
Twitter
Tweets by MSSQLWIKI
-
Do you have a question in SQL Server or stuck in SQL Server issue? Click here to join our facebook group and post your questions to SQL Server experts
-
Join 9,949 other subscribers
SQLWiki
Subscribe
feedburner email subscription
Visits
-
SQL Server Blogs
- Running 1 Million databases on Azure SQL
- Top SQL Server blogs from MSSQLWIKI
- SQL Server connectivity, Kerberos authentication and SQL Server SPN (Service Principal Name for SQL Server)
- Transactional Replication Part -2
- Transactional Replication Part -1
- Tempdb latch contention
- Troubleshooting Transactional replication Latency using Agent Statistics
- The connection to the primary replica is not active. The command cannot be processed
- False warning “A significant part of sql server process memory has been paged out”
- What does MemoryUtilization in sys.dm_os_ring_buffers and Memory_utilization_percentage in sys.dm_os_process_memory represents?
- SQL Server monitor
- 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
- SQL Server 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?
Author
Other SQL blogs
SQLSERVERSCRIBBLES.COM- Integration Services server cannot be configured because there are active operations. Wait until there are no active operations, and then try to configure the server again
- SQL Server setup fails with “Failed to retrieve data for this request”
- The selected Subscriber does not satisfy the minimum version compatibility level of the selected publication.
- Sp_rename fails : Either the parameter @objname is ambiguous or the claimed @objtype (object) is wrong.
- SSIS package fails with out of memory errors
- Cannot bring the Windows Server Failover Clustering (WSFC) resource (ID ‘ ‘) online (Error code 5018).
- SQL Server cluster installation checklist
- PREEMPTIVE_OS_AUTHORIZATIONOPS waits in SQL Server
- SQL Server Backup compression
- Types of isolation levels in SQL Server
MSSQLWIKI 
subahan said
Hi karthic ,
i have facing the below problem …..
I am Getting below alert in one of SQL Server 2012 production server.
“No catalog entry found for partition ID 5620515527371653120 in database 2. The metadata is inconsistent. Run DBCC CHECKDB to check for a metadata corruption.”
Can anyone please suggest what action needs to be taken. i have some idea about this and i need your ideas… please share ur ideas.
Thanks in advance….
subahan M(subahanmssql@gmail.com)..
lustige bilder zum totlachen said
It’s really a great and useful piece of info. I’m glad that you shared this useful information with us.
Please stay us informed like this. Thank you for sharing.
parikshit bisht said
I have few doubt which i need to clear. Please help me to understand the concept.
In sql 2012, multipage allocation happen in buffer pool but In earlier version, buffer pool will maintain single page allocation and MTL will maintain multipage allocation.(8 kb of contiguous chunk)
In earlier version MTL contain the query plan more than 8 kb, extended stored procedure, linked server execution, sql clr and com object.
Doubt 1- In sql 2012, MTL is still available or not. If it is available then what all things resides in it. If it is not available then all those thing which comes under mtl come in buffer pool.
Doubt 2- In sql 2005 32 bit, if we want paging will not happen in buffer pool then we will enable AWE along with LPIM and assign max server memory to sql.
In sql 2012 why LPIM not required ? If we have 50 gb of phyical ram, and we assign 30 gb to sql server. Then paging will not happen because we restrict sql to 30 gb. But after some months, if i will add 30 more gb RAM and allocate 60 gb to sql then why we not required LPIM like in earlier version
Doubt 3:- In sql server 2005 32 bit machine, Maximum memory we have 4 GB. Out of 4 GB of RAM 2 GB for User Mode and 2 GB for kernal mode.
What about in SQL Server 2005 64 bit machine, if suppose RAM is 70 GB then how much memory is taken by user mode and how much taken by kernal mode.
Any changes in higher version regarding memory distribution on kernal and user mode. If yes then please let me know
Doubt 4:- In SQL Server 64 Bit architecture, MTL Scope is available or Not. If it is not available then it means MTL only come to the scope when machine is 32 Bit
If MTL is available in 64 Bit architecture, then it is available on all version or restricted upto SQL 2012