System Health Check (Calvin Schentke)

Get-SuggestedMaxDOP

SQL Server

The query will show the suggested DOP

SQL-Set-DOP

Get-AuditLevel5

Bepoz

This does a check to see if there are any audits stuck on level 5, normaly caused by a error that has spammed this causing Smartcontroller to crash and use high system resources.
The function simple set level 5 audits to 4 reducing the bottleneck.

BEPOZ-Set-AuditsLevelTolevel4

Get-StupidPromos

Bepoz

Overview of all promos in the database that are set to Product groups with mulitple selling sizes

These promos should be changed to use Sort and or Type setups instead to reduce Bepoz Overhead

Get-ProductProfiles

Bepoz

Product Profiles that are missing the IncludedProdGroupID which means the form is set to blank this causes Smartcontroller startup warnings and offline databases fail to create
Either Repair the Product Profiles or Delete the invalid setups

Get-AuditErrors

Bepoz

Overview of TOP 10 AUDIT COUNT BY AUDITTYPE 209 (ERROR)

Get-SQLmemory

SQL Server

Overview of the current SQL memory Allocation

SQL-Set-Memory

Get-SQLDOP

SQL Server

SQL DOP (Degree of Parallelism) in SQL Server refers to the number of processor cores that can be used to execute a single query task simultaneously. When a query is executed, SQL Server's Query Optimizer may choose to split the task into multiple smaller tasks that can run concurrently on different CPU cores. The degree of parallelism determines how many cores can be used for this purpose. By default, SQL Server dynamically decides the DOP based on the available system resources and the complexity of the query. However, administrators can configure the maximum DOP using the max degree of parallelism option to control the number of cores allocated for parallel processing, optimizing performance according to the server's workload characteristics and hardware capabilities. Properly tuning DOP can enhance query performance, especially for complex and resource-intensive queries, but it requires careful balancing to avoid potential overhead from excessive parallelism. the

SQL-Set-DOP

Get-SQLCOT

SQL Server

The "cost threshold for parallelism" is a vital configuration option in SQL Server that helps optimize query performance by controlling when parallel execution plans are considered. Adjusting this setting appropriately based on your server’s workload can lead to significant performance improvements

Default if 5 but recommended is between 25-50

SQL-Set-CostThreshold

Get-SQLCompatibilityLevel

SQL Server

Quick overview of the Current compatibilty that the Database is set too. This Allows gradual adoption of new features and syntax within SQL, but most importantly Query Optimizer Improvements

BEPOZ 4.6 should be greater 100 but below 150 and BEPOZ 4.7 should be as high as possible

Get-SQLlogSize

SQL Server

Quick overview of how big the LDF file size currently is and the ability to resize this to minimum

SQL-Resize-Log

Get-BPZBackup

Bepoz

Quick overview on how many Backups to keep

Get-SmartControlMemoryUsage

Windows

Quick overview of How much Memory Smartcontroller is working if you notice it is running High then there should be cause for concern and it should be investiaged to see what might be causing Smartcontroller to be running hot.

Get-BPZCloudStatus

Bepoz

Just a quick check to see if Bepoz is set to use Cloud Databases.

Get-PriceLevelChange

Bepoz

This shows all curent price jobs that contain a active schedule | all Function button setup are filtered out

Get-Frameworks

Windows

Quick check to see if windows is running Frameworks 4.8 mostly for Version 4.7.X

Windows-Install-NetFramework48

Get-SplitTableWithPayments

Bepoz

The Scans the Maps Table and looks at Function maps that have Payment options on the PNLSplitTable like Save and Send and Cash and EFTPOS, these should be amended and removed.

Search-SmartControlEvents

Windows

Quick Powershell version of Windows Events that allows you to type in for example Smartcontrol.exe and it will find all the events for the last 7 days.

Windows-Search-ApplicationEvents

Get-SQLMaxConnectionsError

Bepoz

Scan audits for a error log “All pooled connections were in use and max pool size was reached" if the system returns results it suggest to increase the maxpoolsize with the provided function

BEPOZ-Set-MaxPoolSize

Get-InvalidProductNames

Bepoz

This check the database for any name that might have invalid XML character mostly in the name field, know to cause problems with SmartPrint Spaming dockets.

Get-RetentionDetails

Bepoz

Simple Check to give you an overview of what retention settings are being used for HO and Remote Sites and the ablity to set the Retention to Defaults.

Bepoz-SetRetentionforAllVenues_13_Months_Excluding_HO

Get-VoucherFromHO

Bepoz

Simple check to see if Venue is using Get-Vouchers from HO.

Get-SalesSummaryCompare1year

Bepoz

Quick overversion on how much Space summary data is using and if you would like to delete any summary data older than 1 year, used for Remote Multivenue Databases

Bepoz-Delete_SummaryData_Older_1_YEAR

Get-DefenderExclusions

Windows

Only for Windows Defender but that set exclusion to Bepoz folder and SQL file types and services so that they are not scanned resulting in a performance boost, most seen when upgrading bepoz.

Windows-Set-SQL_Bepoz_DefenderExclusions

Get-XMLfilesBEPOZDATA

Bepoz

Check the Bepoz\Data directory for XML files and outputs an count, this is just to highlight that in 4.6/4.7 most of the xml files are no longer required and should be cleared out.

Get-InternetSpeedTest

Windows

Check the current speed of the site

Other Functions

Application

Info

BEPOZ-SnapshotsCheck

Bepoz

{Alpha} , needs work but the idea is it checks all the areas that are required to ensure snapshots is correctly configured and can recieve a connection.

Bepoz-MaintainIndexes

SQL Server

The creates a storeprocedure that defrags index's, it used to optimize a database and reduce space

Bepoz-Set-ApplicationkeepAlive_2Min

Bepoz

This set a keep-alive for Bepoz where in some venues a firewall will terminate connections when idle

Windows-Disable-WindowsNotificationOptions

Windows

• Disable "Show the Windows welcome experience after updates and when signed in to show what’s new and suggested"

• Disable "Suggest ways to get the most out of Windows and finish setting up this device"

• Disable "Get tips and suggestions when using Windows"

Windows-Set-WindowsUpdateSettings

Windows

• Set Defer Feature and Quality Updates

• Configure Automatic Updates

• Set Active Hours

• Disable receiving updates for other Microsoft products

• Refresh settings and scan for updates

Bepoz-Set-Smartcontrol_InstanceMonitor

Bepoz

Used for System where they tend to get Multiple Smartcontrollers running in the background this scans every 10 second and if it see more than 1 instance of SC will terminate both and start 1 copy of SC

Bepoz-Set-AzureServerTimeout_DownloadTime

Bepoz

Azure donwloadBlob: The client not finish the operation within specific timeout.

Used to increase the default timeout of Azureblob downloads

By default, the ServerTimeout is set to 60 seconds and MaximumExecutionTime Default is set to 300 seconds

Get-AccountErrors_h

Bepoz

BACKOFFFICE LOADING SLOW? | This checks Accounts for Circular or Disconnected Hierarchy in Accounts where ParentID and Paths are Invalid

This causes a loop on backoffice startup to take longer than expected which causes the delay and slowness in loading and login times.

N/A