-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

SQL Geek

Dharmendra is a SQL Server/Microsoft Data Platform professional with over eight years of experience. He enjoys helping others in the SQL Server community and does this by contributing on blogs, speaking at several SQL events. His passion and focus is to explore and share more and more on SQL Server.

Archives: February 2017

Read Statistics Histogram using DMV

DMV: sys.dm_db_stats_histogram (object_id, stats_id) 

For a long time, the DBCC SHOW_STATISTICS command was the only way to get information about statistics. It displays current query optimization statistics for a table or indexed view. It was always a painful task, if you wanted to capture output of the DBCC SHOW_STATISTICS for… Read more

1 comments, 126 reads

Posted in SQL Geek on 22 February 2017

Out of memory error because of the very low virtual address space – Error 701 – Trace Flag 8075

If you are dealing with a SQL Server which got a lot of memory, you may encounter the out of memory (OOM) error because of low “Available Virtual Memory”.

Recently, I assigned more than 820GB memory to one of the SQL Server instances. The instance was dealing with a significant… Read more

6 comments, 191 reads

Posted in SQL Geek on 20 February 2017

After migrating SQL Server from 2005 to higher version, the waits type PAGELATCH_UP increased

Recently, I experienced an interesting issue where I found SQL Server wait type PageLatch_UP went up drastically after migration. Let’s walk through to understand the problem and its solution.

Problem

After migrating SQL Server 2005 instances to higher versions – SQL 2008/SQL 2008 R2/SQL 2012/SQL 2014 and SQL 2016, I… Read more

2 comments, 112 reads

Posted in SQL Geek on 6 February 2017