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,341

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,149

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 BOOST NAV – How to show most 50 heavy queries on SQL SERVER

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 Check Objects “Modify Date” using “sys.all_objects”

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 REPORTING SERVICES (SSRS) LINKS AND NAV DEMO REPORTS

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 SQL Server MAXDOP configuration option for Microsoft Dynamics NAV

%d bloggers like this: