How to use SQL Server Analysis Services (SSAS) query results in Excel with Power Pivot

December 2, 2016 by

Prerequisites for using query results from any Analysis Services model database in Excel through Power Pivot add-in are SQL Server 2014 or higher with installed Analysis Services Tabular instance (Multidimensional is installed by default), deployed Multidimensional or Tabular model database (for data source) and Power Pivot add-in for Excel 2010 or higher (Power Pivot is […]

My journey to PASS Summit 2016 via SQL Shack

October 3, 2016 by

My name is Ahmad Yaseen and I am a senior SQL Server database administrator at Aramex International Company for more than six years, where I started building my experience in the SQL Server administration field. Being a SQL Server Database administrator in such big company is not that easy, as the difficulties that you may face is […]

Troubleshoot SQL query performance using SQL Server 2016 Live Execution Statistics

August 19, 2016 by

SQL Server Management Studio a graphical interactive that allows you to interact with the databases hosted on your servers. SSMS provides you with the ability to write, edit, execute, analyze and monitor your SQL queries. It also helps database administrators answer important questions about the SQL query performance, such as why a query is slow […]

SSRS ReportServer: Service performance counters guide

July 27, 2016 by

SSRS performance counters Measurements of the Reporting Services service (SSRS) monitoring cycle show which resources the reporting process consumes, and also, specific sets of counters show the particular type of the reporting process deployment in use, Native and SharePoint mode. The entire reports processing occurs in the Report Server, which is the core element of […]

The new SQL Server 2016 sample database

July 22, 2016 by

Background We have all learned to love and hate the trusty Bike shop database. Almost every demo or presentation pertaining to SQL Server we do, we use the AdventureWorks sample database. Almost every code sample on books online references AdventureWorks for illustrations and practical explanations of a feature. When SQL Server 2005 was released Microsoft […]

The SQL Server 2014 Resource Governor

July 15, 2016 by

SQL Server Resource Governor was introduced in SQL Server 2008. This feature is used to control the consumption of the available resources, by limiting the amount of the CPU, Memory and IOPS used by the incoming sessions, preventing performance issues that are caused by resources high consumption.

RESOURCE_SEMAPHORE_QUERY_COMPILE

July 6, 2016 by

Description This wait occurs when queries cannot be compiled due to the amount of compile memory currently available. This mostly occurs due to large queries requiring an excessive amount of memory. SQL Server caps the amount of complex queries that can be compiled at once, so increasing the memory allocation will not solve the problem […]

RESOURCE_SEMAPHORE

July 6, 2016 by

Description Occurs while query memory requests cannot be granted due to other concurrent queries. High values of this wait type may indicate excessive number of concurrent queries, or excessive memory requests Resolved by DBAs and Developers Suggested solutions Ensure that statistics are up to date Run a trace/Profiler/Extended Event session along with Windows Performance Monitor […]

PREEMPTIVE_OS_GETPROCADDRESS

July 5, 2016 by

Description This wait accumulates while SQL Server is waiting for the Operating System to return the procedure address so it can execute an extended stored procedure. These procedures are deprecated and should not be used for further development. These procedures run in unmanaged memory space therefore can cause SQL Server to crash if not written […]

PAGELATCH_UP

July 5, 2016 by

Description Page Latches are used to guarantee consistency of index and data pages for user and system objects in-memory. Pages that manage allocations are protected by internal allocation pages (PFS, GAM, SGAM and IAM). This wait type accumulates while page latches are in update mode. Update mode is not just for UPDATE operations. It is […]

PAGELATCH_SH

July 5, 2016 by

Description Page Latches are used to guarantee consistency of index and data pages for user and system objects in-memory. Pages that manage allocations are protected by internal allocation pages (PFS, GAM, SGAM and IAM). This wait type accumulates while page latches are in share/read mode. If this wait type is high then the common problem […]

PAGELATCH_KP

July 5, 2016 by

Description Page Latches are used to guarantee consistency of index and data pages for user and system objects in-memory. Pages that manage allocations are protected by internal allocation pages (PFS, GAM, SGAM and IAM). This wait type accumulates while page latches are in keep mode. The page is collected while SQL Server determines the appropriate […]

PAGELATCH_EX

July 5, 2016 by

Description Page Latches are used to guarantee consistency of index and data pages for user and system objects in-memory. Pages that manage allocations are protected by internal allocation pages (PFS, GAM, SGAM and IAM). This wait type accumulates while page latches are in exclusive mode. If this wait type is high then the common problem […]

PAGELATCH_DT

July 5, 2016 by

Description Page Latches are used to guarantee consistency of index and data pages for user and system objects in-memory. Pages that manage allocations are protected by internal allocation pages (PFS, GAM, SGAM and IAM). This wait type accumulates while page latches are being destroyed. If this wait type is high then the common problem of […]

PAGEIOLATCH_UP

July 5, 2016 by

Description This wait type accumulates while SQL Server is waiting for a page to be retrieved from disk and loaded into memory. The page will be retrieved in update mode (for modify and versioning operations). If this value is high it is likely that disk or memory are not keeping up with the workload Resolved […]

PAGEIOLATCH_SH

July 5, 2016 by

Description This wait type accumulates while SQL Server is waiting for a page to be retrieved from disk and loaded into memory. The page collected will be used for a shared purpose (read operation). If this value is high it is likely disk or memory available are not keeping up with the workload Resolved by […]

PAGEIOLATCH_KP

July 5, 2016 by

Description This wait type accumulates while SQL Server is waiting for a page to be retrieved from disk and loaded into memory. The page collected while SQL Server is still determining the level of latch the page requires, this can occur in Read-Ahead operations. If this value is high it is likely that disk or […]

PAGEIOLATCH_EX

July 5, 2016 by

Description This wait type accumulates while SQL Server is waiting for a page to be retrieved from disk and loaded into memory. The page collected will be used for an exclusive purpose (read or write operations). If this value is high it is likely that disk or available memory are not keeping up with the […]