SQL Profiler Audit Logout duration 18446744073709548
I'm running traces on our SQL Server 2014 box and see something disturbing. The duration column of the Audit Logout event is normally the time in microseconds a connection has been alive to the server and can get quite large due to connection pooling, but what does it mean when it's 18446744073709548?
I cant help to think this number is special. A bit like the value of maxint in .NET etc. I've googled this number and it returns various stuff. A few of them are about SQL server and the audit logout event, so I'm not the only one seeing this, but I cant find an explanation about what it means.
Anyone? (preferably someone who has participated in the development of SQL server ;))
br
Frederic
sql-server sql-server-2014
migrated from stackoverflow.com Nov 28 '18 at 8:39
This question came from our site for professional and enthusiast programmers.
add a comment |
I'm running traces on our SQL Server 2014 box and see something disturbing. The duration column of the Audit Logout event is normally the time in microseconds a connection has been alive to the server and can get quite large due to connection pooling, but what does it mean when it's 18446744073709548?
I cant help to think this number is special. A bit like the value of maxint in .NET etc. I've googled this number and it returns various stuff. A few of them are about SQL server and the audit logout event, so I'm not the only one seeing this, but I cant find an explanation about what it means.
Anyone? (preferably someone who has participated in the development of SQL server ;))
br
Frederic
sql-server sql-server-2014
migrated from stackoverflow.com Nov 28 '18 at 8:39
This question came from our site for professional and enthusiast programmers.
so list your connections......: stackoverflow.com/questions/216007/…
– Mitch Wheat
Nov 22 '18 at 6:32
is your server clustered? AG?
– Mitch Wheat
Nov 22 '18 at 6:35
No, server is standalone.
– Fritzoid
Nov 22 '18 at 8:16
How is Listing the connections going to explain that number?
– Fritzoid
Nov 23 '18 at 12:43
add a comment |
I'm running traces on our SQL Server 2014 box and see something disturbing. The duration column of the Audit Logout event is normally the time in microseconds a connection has been alive to the server and can get quite large due to connection pooling, but what does it mean when it's 18446744073709548?
I cant help to think this number is special. A bit like the value of maxint in .NET etc. I've googled this number and it returns various stuff. A few of them are about SQL server and the audit logout event, so I'm not the only one seeing this, but I cant find an explanation about what it means.
Anyone? (preferably someone who has participated in the development of SQL server ;))
br
Frederic
sql-server sql-server-2014
I'm running traces on our SQL Server 2014 box and see something disturbing. The duration column of the Audit Logout event is normally the time in microseconds a connection has been alive to the server and can get quite large due to connection pooling, but what does it mean when it's 18446744073709548?
I cant help to think this number is special. A bit like the value of maxint in .NET etc. I've googled this number and it returns various stuff. A few of them are about SQL server and the audit logout event, so I'm not the only one seeing this, but I cant find an explanation about what it means.
Anyone? (preferably someone who has participated in the development of SQL server ;))
br
Frederic
sql-server sql-server-2014
sql-server sql-server-2014
asked Nov 21 '18 at 14:07
Fritzoid
migrated from stackoverflow.com Nov 28 '18 at 8:39
This question came from our site for professional and enthusiast programmers.
migrated from stackoverflow.com Nov 28 '18 at 8:39
This question came from our site for professional and enthusiast programmers.
so list your connections......: stackoverflow.com/questions/216007/…
– Mitch Wheat
Nov 22 '18 at 6:32
is your server clustered? AG?
– Mitch Wheat
Nov 22 '18 at 6:35
No, server is standalone.
– Fritzoid
Nov 22 '18 at 8:16
How is Listing the connections going to explain that number?
– Fritzoid
Nov 23 '18 at 12:43
add a comment |
so list your connections......: stackoverflow.com/questions/216007/…
– Mitch Wheat
Nov 22 '18 at 6:32
is your server clustered? AG?
– Mitch Wheat
Nov 22 '18 at 6:35
No, server is standalone.
– Fritzoid
Nov 22 '18 at 8:16
How is Listing the connections going to explain that number?
– Fritzoid
Nov 23 '18 at 12:43
so list your connections......: stackoverflow.com/questions/216007/…
– Mitch Wheat
Nov 22 '18 at 6:32
so list your connections......: stackoverflow.com/questions/216007/…
– Mitch Wheat
Nov 22 '18 at 6:32
is your server clustered? AG?
– Mitch Wheat
Nov 22 '18 at 6:35
is your server clustered? AG?
– Mitch Wheat
Nov 22 '18 at 6:35
No, server is standalone.
– Fritzoid
Nov 22 '18 at 8:16
No, server is standalone.
– Fritzoid
Nov 22 '18 at 8:16
How is Listing the connections going to explain that number?
– Fritzoid
Nov 23 '18 at 12:43
How is Listing the connections going to explain that number?
– Fritzoid
Nov 23 '18 at 12:43
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f223621%2fsql-profiler-audit-logout-duration-18446744073709548%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Database Administrators Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f223621%2fsql-profiler-audit-logout-duration-18446744073709548%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
so list your connections......: stackoverflow.com/questions/216007/…
– Mitch Wheat
Nov 22 '18 at 6:32
is your server clustered? AG?
– Mitch Wheat
Nov 22 '18 at 6:35
No, server is standalone.
– Fritzoid
Nov 22 '18 at 8:16
How is Listing the connections going to explain that number?
– Fritzoid
Nov 23 '18 at 12:43