SQL Server Memory Usage Query
Check out this SQL Server function that can return memory usage information for a SQL Server instance such as the amount of memory SQL Server is using and available memory on the machine.
2021-05-03
SQL Monitoring
Fixing "Login failed for user" error in SQL Server
In this article, I am going to explain fixing a problem related login failure error with SQL Server. The Problem One of the common error in the SQL Server error log is "Login failed for user 'DomainName\ServerName$'. Reason: Could not find a login matching the name provided. [CLIENT: <local machine>]". Even though it says that […]
2020-11-24
21,950 reads
SQL Server Licensing and SQL Monitor
How well do the SQL Server licenses you own match up with what you need for your current use? William Durkin explains how to use SQL Monitor to find out.
2020-07-06
Easily manage SQL Server licensing with SQL Monitor 10.1
SQL Monitor 10.1 now gives you a comprehensive overview of your SQL Server licensing, so you know which licenses are in use, and which versions are on which servers. This simplifies license auditing and lets you unearth misconfigurations that could potentially cost you money. The new version also integrates with Microsoft Teams and Splunk, and supports complex Active Directory environments.
2020-07-02
Cloud adoption rates see increase in 2020
Usage of Microsoft Azure is up by 15 percentage points compared to 2019 and it remains the most-used cloud platform. This is possibly as a result of increased remote working and the need to no longer rely on physical machines. For more insights into 2020 trends and challenges, download the State of Database Monitoring report here.
2020-06-26
When SQL Server Performance goes Bad: the Fill Factor and Excessive Fragmentation
Phil Factor on the fill factor, pages splits and index fragmentation, and how SQL Monitor can help you decide if a custom fill factor for certain indexes might help alleviate performance issues.
2020-06-24
What is the impact of remote working on estate management?
Distributed workforces have very quickly become the norm. The 2020 State of Database Monitoring survey explores the impact of remote working on estate management and how organisations are responding. You can read the full findings in the free report, here.
2020-06-19
Challenges and trends for Database Monitoring in 2020
Nearly 1000 database professionals took part in this year's State of Database Monitoring survey. Providing insights into how they monitor their estates, the technologies they work with, what their biggest challenges are, and emerging trends for 2020. For the detailed analysis of the responses, download your free copy of the report.
2020-06-09
2020-06-01
What’s changed for database monitoring this year?
Have your say on the state of database monitoring in 2020. In this latest blog, Redgate’s Jamie Wallis reviews what we discovered from last year’s survey and how you can define the insights for 2020. Tell us and you can get early access to the report plus be entered for a chance to win a $500 Amazon voucher. Read the blog to find out more:
2020-04-22
Blogs
Errata for my book: Pro Encryption in SQL Server 2022
My biggest fear when my book went into production was that any factual errors...
SQL Server Quickie #45 – SQL Server Availability Groups
Today I have uploaded SQL Server Quickie #45 to YouTube. This time I’m talking...
Daily Coping 21 Mar 2023
By Steve Jones
Today’s coping tip is to listen to a piece of music without doing anything...
Forums
The Nook Spa
The Nook Spa is a safe and healing environment. offering therapeutic massage services, body...
How much RAM in an Azure Database on Pay As You Go
Ive been doing some benchmark testing using an application, running this on my local...
Ask SSC