Vanterra Logistics
DEMO DATA

Vanterra Logistics

Estate 2h Data 6h Azure 22h Fabric today
Data
Azure
Fabric
73% 29 Aug 76% 4 Sept

Fourteen points in five weeks.

Requests
    Azure FinOps
    €27,400 expected by month end, +€2,300 on last month
    • Supplier moved an ERP database into their own subscription +€1,840
    • Freight lab fleet left running through the month +€610
    • Right-size the ERP database the supplier provisioned €1,910/mo
    Azure Score 80 65 50 May Sept

    68 out of 100, up 4 since the last scan. Security is the weakest category at 58.

    Vanterra Logistics - Azure Monitor (preview)

    Snapshot Search alerts, resources, rules
    Azure Environments
    7Firing
    4Critical or error
    2Environments with alerts
    Oldest still firing
    AlertSeverityStateAge

    Vanterra Logistics - Azure FinOps (preview)

    Snapshot Cost Analysis
    Azure Environments
    €18,940This month so far
    €27,400Expected by month end +€2,300 vs last month at this pace
    €25,100Last month
    €3,180Savings you can take

    Why it moved

    Named changes versus last month

    Savings

    Actions you can take this month

    History

    is month-to-date. The lighter cap is the expected remainder.

    Where the money is

    This month so far, by Azure service

    Requests

    Search title, description or number Anyone All types All priorities
    Newest first
    Request Submitted by Created Activity

    Vanterra Logistics - Estate

    Data collected on: search estate
    ServerInstanceProductEdition VersionInstalled UpdateLatest UpdateLast Assessment WarningAttentionInformation Tags
    Found 14 rows

    Tags

    Annotation

    SettingRunning valueConfigured valueRecommended
    RunTypeWarningAttentionInformationResult
    JobScheduleLast runDurationOutcome
    VolumeLabelCapacityFreeFree %
    DatabaseRecovery modelSizeLast full backupCompatibilityState
    GroupReplicaRoleAvailability modeSynchronisation

    Vanterra Logistics - Performance

    Data collected on: VNT-SQL-PRD-03
    Hours of WaitstatsWaitStatWaiting Tasks Count Avg MS / waitTotal Hours of Wait% CPU Time % of Total Waits% Signal Wait
    DatabaseDriveFile Name Read Latency msWrite Latency msTotal Latency ms Avg Byte / ReadAvg Byte / WriteAvg Byte / Transfer
    Vanterra Logistics - Data Assessments
    All instances
    Findings per run
    0 20 40 60 80 63 findings 61 findings 59 findings 57 findings 51 findings 47 findings

    Assessment details

    search findings
    · 17 instances
    Warning

    Backup verification has not run for 41 days on VNT-SQL-PRD-03

    What we found

    Full backups are written for all 26 databases on this instance, but no restore verification has succeeded since 26 July. A backup nobody has restored is an assumption, not a recovery plan.

    Why it matters to you

    Vanterra's freight tracking database sits on this instance. If a restore fails when you actually need it, your recovery point is the last verified backup, which is six weeks old. That is a reportable data loss, not an IT inconvenience.

    What to do

    Re-enable the verification job on the maintenance plan and let it run against the secondary. Cortex confirms it on the next daily run and closes the finding on its own.

    Instance
    VNT-SQL-PRD-03
    Location
    Rotterdam DC
    Databases affected
    26
    Last verified restore
    2026-07-26
    First seen
    2026-07-27
    Check
    sp_Blitz 12
    Warning

    Four databases hold personal data without TDE enabled

    What we found

    Transparent Data Encryption is off on four databases holding driver and consignee records. The data files and every backup of them are readable by anyone who can copy the file off the volume.

    Why it matters to you

    These databases fall under GDPR. Unencrypted at rest is the finding an auditor writes down first, and it is a one-setting fix.

    Instance
    VNT-SQL-PRD-01
    Databases affected
    4
    First seen
    2026-08-27
    Check
    CIS 5.2
    Warning

    Availability group has not synchronised for 3 days

    What we found

    The secondary replica in Frankfurt is behind by 3 days and 40 GB of log. The group still reports as configured, which is exactly why this is easy to miss.

    Why it matters to you

    You are paying for a high availability setup that would not currently fail over. The gap widens every day it goes unnoticed.

    Group
    VNT-SQL-AG-02
    Secondary
    Frankfurt
    Log queue
    40.2 GB
    First seen
    2026-09-02
    Attention

    Autogrowth set to 1 MB on a 2.4 TB database

    What we found

    The warehouse database grows in 1 MB steps. Every growth event pauses writes, and at this size it happens hundreds of times a day.

    Why it matters to you

    This is the slow, invisible tax that gets reported as "the system feels sluggish in the afternoon". It costs nothing to fix.

    Database
    VNT_Warehouse
    Size
    2.4 TB
    Growth events, 24h
    417
    Attention

    SQL Server 2014 and 2016 are out of extended support

    What we found

    One instance runs SQL Server 2014 SP3 and one runs SQL Server 2016 SP3. Extended support ended on 9 July 2024 and 15 July 2026, so neither receives security updates unless you buy an Extended Security Updates subscription.

    Why it matters to you

    This is a budget line, not a ticket. Both boxes are running unpatched today, and an ESU subscription costs a percentage of the licence every year you delay.

    Instances
    2
    SQL Server 2014
    12.0.6024.0
    SQL Server 2016
    13.0.6300.2
    Support ended
    2024-07-09
    Support ended
    2026-07-15
    No checks match the current filters.
    Vanterra Logistics - Azure Assessments
    Scanned 2026-09-04 23:40 3 subscriptions

    Azure Advisor score

    Microsoft's own rating of your tenant, pulled straight from Advisor.

    68/100
    Up from 64 last month
    Security58
    Cost61
    Reliability72
    Operational excellence74
    Performance81

    What the Azure scan turned up

    38 recommendations across Vanterra's three subscriptions, graded the way Microsoft grades them.

    €3,180 per month in identified savings, mostly oversized compute in West Europe
    3
    Subscriptions
    247
    Resources scanned
    2
    Regions in use
    38
    Recommendations

    Recommendations (3)

    RecommendationSubscriptionRegionImpact

    What we found

    The freight tracking database accepts connections from any IP address. The firewall rule that opened it was added for a migration in March and never removed.

    Why it matters to you

    Your most sensitive database is reachable from the public internet and protected only by a password. A private endpoint closes it in an afternoon.

    Resource
    sql-vnt-track-01
    Subscription
    vanterra-production
    Region
    West Europe
    Category
    Security

    What we found

    Backup redundancy is set to locally redundant. A regional outage in West Europe takes the database and its backups at the same time.

    Why it matters to you

    Vanterra's own continuity policy promises a second region. Right now the configuration does not deliver it.

    Resource
    sql-vnt-track-01
    Redundancy
    Local
    Category
    Reliability

    What we found

    Six machines have run below 12 percent CPU for thirty days. Advisor puts the saving from resizing them at 3,180 euro a month.

    Why it matters to you

    This is the part of the report that pays for the assessment. It is also the easiest to act on, because nothing about the workload changes.

    Machines
    6
    Monthly saving
    €3,180
    Category
    Cost
    No recommendations match the current filters.
    Vanterra Logistics - Fabric Assessments PREVIEW

    Fourteen points in five weeks, almost all of it from reattaching workspaces that had drifted off a capacity. Pick any run to see how it broke down.

    Rule Results (7)

    search findings
    RuleCategorySeverityStatus

    Message

    The Freight Analytics workspace is not assigned to any Fabric capacity. Its reports fall back to shared capacity, where refreshes queue behind everyone else's.

    Why it matters to you

    This is the workspace the planners open at 06:00. Detached workspaces also sit outside your capacity governance, so nobody is watching what they cost.

    Target
    Freight Analytics
    Rule ID
    R0005
    Category
    Licenses
    Severity
    High
    Timestamp
    2026-09-04 02:10

    Message

    Same rule, different workspace. Warehouse Reporting also sits outside every capacity, which is why Cortex lists it as its own row instead of folding it into a count.

    Target
    Warehouse Reporting
    Rule ID
    R0005
    Severity
    High

    Message

    The nightly refresh has failed 11 of the last 14 nights on a credential error. The report still opens, showing data from 22 August.

    Why it matters to you

    A stale report that looks fresh is worse than a broken one. Customers are quoting delivery times from three-week-old numbers.

    Target
    Customer Portal
    Rule ID
    R0018
    Failed refreshes
    11 of 14

    Message

    The only administrator on this workspace left the company in June. Nobody can grant access or change the refresh schedule.

    Target
    Finance Consolidation
    Rule ID
    R0031
    Severity
    Medium

    Message

    The F16 capacity hit its ceiling on 9 of the last 10 working days between 08:00 and 10:00, and queries were throttled.

    Why it matters to you

    Either the capacity is a size too small or the refresh window is in the wrong place. Cortex shows which, so you are not guessing before you buy more.

    Target
    Freight Analytics
    Capacity
    F16
    Rule ID
    R0012

    Message

    Nine published reports carry no sensitivity label, so they can be exported and shared outside the tenant without restriction.

    Target
    Sales Dashboards
    Reports affected
    9
    Rule ID
    R0027

    Message

    Six reports in this workspace have had no viewers in 90 days, but they still refresh nightly and consume capacity.

    Why it matters to you

    Retiring these is the cheapest capacity you will ever buy back.

    Target
    HR Reporting
    Reports affected
    6
    Rule ID
    R0022
    No rules match the current filters.
    Interactive demo

    See what Cortex knows about a data estate

    This is the Cortex interface, filled with data from a company that does not exist. Vanterra Logistics is a fictional Rotterdam freight operator with 17 SQL Server instances, three Azure subscriptions and a Microsoft Fabric tenant.

    Every name, number and finding in this demo is invented. No customer data appears anywhere in it.