tsre 5 elevated track will not add to database

There is usually, but not always, a 1:1 relationship between connections and sessions. SQL Monitor’s built-in User Connections metric gives us only instance-level data for the total number of connections, at any time. Tracking the number of recently-active sessions Then, we can investigate further using queries such as those above. This may be interesting, but first we want to find out what is a ‘usual’ number of active sessions for each of the databases, so that we can tell if the number of active sessions leaps, for any reason or suddenly drops to zero (never a good sign). OUTER APPLY : : fn_get_sql ( sql_handle ) Listing 1 shows a quick query to tell you how many sessions are being used by each login name on each database on a server We therefore need to track SPIDs and logins.

Sadly, we don’t always live in an ideal world, especially in IT. The better your security, the more users you are likely to have in proportion to the sessions, because it means that users are not sharing logins. Ideally, this shouldn’t happen each user should be using their unique Windows login, thereby enabling you to audit what is going on properly. This is especially true if you have a shared connection to the application under one User ID, so that there are many people or processes using one login name. How many users are on your databases? Well, there could be just one user (login) doing one heck of a lot, using many sessions. I’ve already discovered problems by tracking this metric, one where a process I thought was disabled had somehow restarted, and another where a database was showing no activity when it should have had some! Who’s using your databases and what are they doing?

At this point, there are plenty of ways in SQL to find out, in detail, which users are active, and what they are up to. Once SQL Monitor is attuned to the usual ebbs and flows in this figure, you’ll have a baseline for each database, and will be able to spot suspicious or unusual patterns of usage. With a bit of SQL, we can create a custom metric to track how many sessions recently performed reads or writes on a database, such as in the last ten minutes. It’s surprisingly useful to know the number of active sessions on each of the databases on your servers. He is a regular contributor to Simple Talk and SQLServerCentral. Phil Factor (real name withheld to protect the guilty), aka Database Mole, has 30 years of experience with database-intensive applications.ĭespite having once been shouted at by a furious Bill Gates at an exhibition in the early 1980s, he has remained resolutely anonymous throughout his career.

Tsre 5 elevated track will not add to database