SQL

The latest release of ManageEngine ServiceDesk Plus MSP changes the default user and password of the Postgres SQL database. Previously, the command to connect to the database was: psql -U postgres -p 65432 -d servicedesk -h 127.0.0.1 The new change shows that there is a change in username and password as follows: psql -U sdpadmin…

Read More ServiceDesk Plus MSP 10.5 Postgre SQL password

Microsoft made the following changes in their documentation (see screenshot above) to accurately reflect the memory limits on lower editions of SQL Server. Edition Information:  https://www.microsoft.com/en-us/sql-server/sql-server-editions Estimate Memory Requirements for Memory-Optimized Tables Key Points The limits for In-Memory OLTP data is per database. The limits for Columnstore segment cache is per SQL Server instance across all the…

Read More SQL Server 2016 SP1 Edition Limit Changes

I wrote this script to defrag all the found MDF and LDF files on a server that I’ve been testing on.  It uses Sysinternal’s Contig tool which is a single-file defrag tool. @echo off : Rich Kreider : : You need contig.exe from sysinternals: http://live.sysinternals.com/contig.exe SETLOCAL set MINFRAGMENTS=5 set CONTIGBIN=c:tempcontig.exe if not exist %CONTIGBIN% goto…

Read More Defrag SQL MDF and LDF on Server

Scenario:   Guest VM Total Memory:  64GB SQL Server Max Memory:  58GB (Leaving 10%, or 6.4GB roughly for Windows + Apps) Guest VM Reservation:  48GB (75% of  Guest VM Total Memory;  in certain scenarios, 100% is preferred — if you can support it in failure situations) SQL Server Min Memory:  43GB which gives 5GB to Windows…

Read More SQL Server Min and Max in Virtualization

Here is a list of Windows’ performance counters to use in monitoring performance of an SQL server. Create Performance Collection rules targeted to a SQL Server computer group for the following performance counters: LogicalDisk(*)Avg Disk sec/Read Should be under 20ms. Beyond 50ms is very bad LogicalDisk(*)Avg Disk sec/Write Should be under 20ms. Beyond 50ms is…

Read More Monitor SQL Performance

From Paul Randal’s survey of highest wait on server TSQL.   WITH Waits AS (SELECT wait_type, wait_time_ms / 1000.0 AS WaitS, (wait_time_ms – signal_wait_time_ms) / 1000.0 AS ResourceS, signal_wait_time_ms / 1000.0 AS SignalS, waiting_tasks_count AS WaitCount, 100.0 * wait_time_ms / SUM (wait_time_ms) OVER() AS Percentage, ROW_NUMBER() OVER(ORDER BY wait_time_ms DESC) AS RowNum FROM sys.dm_os_wait_stats WHERE…

Read More SQL Server: Find Highest Wait on Server