sp_whopro™ – SQL Server Activity Monitoring and Logging Stored Procedure

sp_whopro™ – SQL Server Activity Monitoring and Logging Stored Procedure Great SQL Script ! Source: SQLDownload Download Post Views: 1,365

Top 10 SQL Server Counters for Monitoring SQL Server Performance — DatabaseJournal.com

Greg Larsen lists his top 10 SQL Server counters for maintaining database performance. Sorgente: Top 10 SQL Server Counters for Monitoring SQL Server Performance — DatabaseJournal.com Great post by Greg Larsen. Post Views: 1,159

BOOST NAV – How to show most 50 heavy queries on SQL SERVER

BOOST NAV – How to show most 50 heavy queries on SQL SERVER … very nice SQL Script to discover slow Sessions !! SQL SCRIPT SELECT TOP 50 SUBSTRING(qt.TEXT, (qs.statement_start_offset/2)+1, ((CASE qs.statement_end_offset WHEN –1 THEN DATALENGTH(qt.TEXT) ELSE qs.statement_end_offset END – qs.statement_start_offset)/2)+1), qs.execution_count, qs.total_logical_reads, qs.last_logical_reads, qs.total_logical_writes, qs.last_logical_writes, qs.total_worker_time, qs.last_worker_time, qs.total_elapsed_time/1000000 total_elapsed_time_in_S, qs.last_elapsed_time/1000000 last_elapsed_time_in_S, qs.last_execution_time, qp.query_plan FROM … Read more

Check Objects “Modify Date” using “sys.all_objects”

If you need to check “Modify Date” for NAV Objects on SQL Server, you can use SQL Standard Function “sys.all_objects“; you don’t need to use standard NAV Objects Table.   Examples: USE [Demo Database NAV (7-1)]  GO — VIEWS SELECT * FROM sys.all_objects WHERE type_desc like ‘VIEW’ ORDER BY modify_date DESC — TABLES SELECT * FROM … Read more

SQL SERVER REPORTING SERVICES (SSRS) LINKS AND NAV DEMO REPORTS

SQL SERVER REPORTING SERVICES (SSRS) LINKS AND NAV DEMO REPORTS LINKS Developing Report Navigation and Drilldown https://technet.microsoft.com/en-us/library/aa964132(v=sql.90).aspx Migrating from Business Objects Crystal Reports to SQL Server 2005 Reporting Services https://technet.microsoft.com/en-US/library/aa964127(v=sql.90).aspx Migrating Crystal Report Sections to SQL Server 2005 Reporting Services https://technet.microsoft.com/en-US/library/aa964127(v=sql.90).aspx Reporting Services Tutorials https://msdn.microsoft.com/en-us/library/ms170246.aspx Reporting Services Samples https://msdn.microsoft.com/en-US/library/ms160954(v=sql.105).aspx Reporting Services (SSRS) https://msdn.microsoft.com/it-it/library/ms159106.aspx DEMO REPORTS … Read more

SQL Server MAXDOP configuration option for Microsoft Dynamics NAV

SQL Server MAXDOP configuration option for Microsoft Dynamics NAV My question to NAV Team about suggested configuration  : ‘SET MAXDOP =  ????’  with NAV 2009, 2013, 2015 ???? http://blogs.msdn.com/b/nav/archive/2015/06/03/sql-server-worker-threads-and-microsoft-dynamics-nav.aspx Configure the max degree of parallelism Server Configuration Option https://msdn.microsoft.com/en-us/library/ms189094.aspx?f=255&MSPPError=-2147217396 sp_configure ‘show advanced options’, 1; GO RECONFIGURE WITH OVERRIDE; GO sp_configure ‘max degree of parallelism’, 1; … Read more

%d bloggers like this: