Skip to content
SQL Server database

Run SQL Server BLOG

Just another Select of Ms SQL DBA site

Tag: virusscan

Posted on 15th April 202114th April 2023

In memory OLTP database with Defender VirusScan setting

If you do not set the recommended VirusScan settings for SQL you can see some overhead.

In-memory OLTP SQL

Performance monitor
Performance monitor

I switched off the Windows Defender VirusScan between 1:29 – 1:40
Pages/sec in Memory and Disk reads is less wit turned off VirusScan.

Pages

  • AI
  • Azure Labs
  • MS SQL DB useful pages
  • PostgreSQL pages

DBA

Recent Posts

  • The SQL Server Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service. Windows return code0x21c7, state: 15
  • Missing index
  • Check the SQL Server version
  • DateTime calculator to UTC to Local Server time to a specific TimeZone
  • Install Oracle in docker

Recent Comments

  • Mel on SSISDB update failed during the SQL CU or SP udpate
  • Jordan Rieger on SSISDB update failed during the SQL CU or SP udpate
  • Gabor on SQL Database downgrade internal version 869 and 852 and Compatibility Level
  • FAHAD J. ALMASOUDI on SQL Database downgrade internal version 869 and 852 and Compatibility Level
  • Bodnar Gabor on Performancia – tranzakciók ideje

Archives

  • April 2025
  • January 2025
  • September 2024
  • July 2024
  • February 2024
  • October 2023
  • June 2023
  • May 2023
  • April 2023
  • January 2023
  • December 2022
  • September 2022
  • April 2022
  • March 2022
  • February 2022
  • January 2022
  • December 2021
  • October 2021
  • September 2021
  • August 2021
  • July 2021
  • April 2021
  • January 2021
  • December 2020
  • October 2020
  • July 2020
  • February 2020
  • January 2020
  • December 2019
  • March 2019
  • January 2019
  • November 2018
  • September 2018
  • July 2018
  • June 2018
  • May 2018
  • April 2018
  • March 2018

Categories

  • book
  • dbatools
  • docker
  • oracle
  • PowerShell
  • Python
  • SQL
  • Uncategorised
  • Windows

Tags

  • 852
  • 869
  • AOAG
  • backup
  • cache
  • check
  • commit time
  • compare results
  • compatibility level
  • dbatools
  • downgrade
  • DTC
  • ebook
  • ellenőrzés
  • free space
  • Heap
  • Heap table
  • hyper-v
  • index
  • index fragmentation
  • index size
  • internal version
  • könyv
  • performance
  • performance monitor
  • performance tuning
  • performancia
  • powershell
  • recovery
  • restore
  • running time
  • script
  • session
  • size
  • SQL
  • SQL counters
  • SQL Server 2019
  • statistics
  • test
  • text
  • time
  • tippek
  • tuning
  • VMware
  • összehasonlítás

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
  • MS SQL DB useful pages
Proudly powered by WordPress