January 1, 2014 at 9:52 pm
Hello.
I got this problem in my Production Environment.
SQL Server Instance Logins per Second is 4 Logins/Sec, where the threshold is 2 Logins/Sec.
Where do I start to solve this problem?
Thanks for the advice.
Andy
January 2, 2014 at 12:03 am
Why is 2 logins/sec the threshold and is this a problem? What's normal for this server?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 2, 2014 at 12:33 am
It's set before I came in here by previous DBA.
Any guidance in deciding the threshold?
I'm quite new in administration.
January 2, 2014 at 12:46 am
A threshold should be above what is normal for your server.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 2, 2014 at 5:19 am
Unless there's a specific reason for it, 4 logins/sec isn't freaking me out. It's just an indication of load, not a problem.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 2, 2014 at 5:25 am
How can I determine the 'normal threshold' for my server?
Count of user login?
January 2, 2014 at 5:29 am
The only way to determine "normal" for any system is to measure it over time.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 2, 2014 at 5:53 am
Andy CP (1/2/2014)
How can I determine the 'normal threshold' for my server?
Monitor it for a period of time, see what the particular counter you're interested in (logins/sec in this case) has as a range. That's 'normal' for your server.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 8 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply