SQL Server Performance

how many connection now?

Discussion in 'General DBA Questions' started by erickwidya, Jul 14, 2005.

  1. erickwidya New Member

    is it possible to know how many connection for certain Database?
    and how many Total connection?

    and if possible to know the detail for all of them like
    Database1 : 5 connection
    Database2 : 2 connection
    ...

    is there any security related article in MSSQL 2000 that i can read?

    thanks
  2. ghemant Moderator

    hi, <br />very first run sp_helpdb to get the list of system and user's db and dbid of the same <br />then <br />you can run <b>select count(dbid) from sysprocesses where dbid=yrdbid</b> to check how many users are connected for particular dbid / databse ....<br /><br /><br />HTH<br /><br /><br />[<img src='/community/emoticons/emotion-4.gif' alt=':p' />][}<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br />Regards.<br /><br /><br /><br />hsGoswami<br />ghemant@gmail.com
  3. Madhivanan Moderator

    That should be Master..Sysprocesses
    Running the Profiler may help you to get these info


    Madhivanan

    Failing to plan is Planning to fail
  4. erickwidya New Member

    thanks <b>Madhivanan and ghemant</b><br /><blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote">Running the Profiler may help you to get these info<hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote">not sure how to use it..can u elaborate more?<br /><br /><blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote">very first run sp_helpdb to get the list of system and user's db and dbid of the same<br />then<br />you can run select count(dbid) from sysprocesses where dbid=yrdbid to check how many users are connected for particular dbid / databse ....<hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"> exatcly what i want<br /><br />about security related, can u guys/girls provide any good link?<br />i already search sql-performance but it seem to many articles that involved <img src='/community/emoticons/emotion-6.gif' alt=':(' /><br /><br />thanks
  5. satya Moderator

    http://www.sql-server-performance.com/vk_sql_security.asp
    http://www.microsoft.com/sql/techinfo/administration/2000/security/
    http://www.databasejournal.com/features/mssql/article.php/2243271

    Your question is not clear whether you want to restrict number of connections against server/database, get a list of connections or deploy better security.



    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  6. erickwidya New Member

    thanks <b>satya</b><br /> <blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote">Your question is not clear whether you want to restrict number of connections against server/database, get a list of connections or deploy better security.<hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br />sorry if my question not clear..<br /><br />i want to get a list of connection, for the security is something that i need to understand the basic for it..so instead i asking silly questions <img src='/community/emoticons/emotion-1.gif' alt=':)' />, i better reading it first what security looks like in MSSQL 2000<br /><br />hope it more clear than before<br /><br />thanks
  7. ghemant Moderator

    hi erick,<br />refer the link below :<br /><b><a href='www.sqlsecrity.com' target='_blank' title='www.sqlsecrity.com'>www.sqlsecrity.com</a></b><br /><b><a href='www.mssqlcity.com' target='_blank' title='www.mssqlcity.com'>www.mssqlcity.com</a></b><br /><b><a href='www.microsoft.com/sql/2005/ productinfo/securityfeatures_1.asp' target='_blank' title='www.microsoft.com/sql/2005/ productinfo/securityfeatures_1.asp'>www.microsoft.com/sql/2005/ productinfo/securityfeatures_1.asp</a></b><br /><b><a href='www.netlib.com/sql-server-encryption.shtml' target='_blank' title='www.netlib.com/sql-server-encryption.shtml'>www.netlib.com/sql-server-encryption.shtml</a></b><br /><b><a href='vyaskn.tripod.com/ sql_server_security_best_practices.htm' target='_blank' title='vyaskn.tripod.com/ sql_server_security_best_practices.htm'>vyaskn.tripod.com/ sql_server_security_best_practices.htm</a></b><br /><b><a href='vyaskn.tripod.com/sql_server_security_distilled.htm' target='_blank' title='vyaskn.tripod.com/sql_server_security_distilled.htm'>vyaskn.tripod.com/sql_server_security_distilled.htm</a></b><br /><b><a href='www.nextgenss.com/papers/advanced_sql_injection.pdf' target='_blank' title='www.nextgenss.com/papers/advanced_sql_injection.pdf'>www.nextgenss.com/papers/advanced_sql_injection.pdf</a></b><br /><b><a href='www.securitymap.net/sdm/ docs/windows/mssql-checklist.html' target='_blank' title='www.securitymap.net/sdm/ docs/windows/mssql-checklist.html'>www.securitymap.net/sdm/ docs/windows/mssql-checklist.html </a></b> <br /><br /><br /><br />HTH<br /><br /><br />[<img src='/community/emoticons/emotion-1.gif' alt=':)' />][<img src='/community/emoticons/emotion-2.gif' alt=':D' />][:I]<br />Regards.<br /><br /><br /><br />hsGoswami<br />ghemant@gmail.com<br />"Humans don't have Caliber to PASS TIME , Time it self Pass or Fail Humans" - by Hemant Goswami<br />
  8. satya Moderator

    Erick<br />Now you are clear and you asked for links then it will be flooded [<img src='/community/emoticons/emotion-2.gif' alt=':D' />], have a good reading on above links.<br /><br /><hr noshade size="1"><b>Satya SKJ</b><br />Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com/forum>http://www.SQL-Server-Performance.Com/forum</a><br /><center><font color="teal"><font size="1">This posting is provided “AS IS” with no rights for the sake of <i>knowledge sharing.</i></font id="size1"></font id="teal"></center>
  9. ghemant Moderator

    Good time Erick,<br /><br />[:I][<img src='/community/emoticons/emotion-2.gif' alt=':D' />]<br /><br /><br /><br />Regards.<br /><br />hsGoswami<br />ghemant@gmail.com<br />"Humans don't have Caliber to PASS TIME , Time it self Pass or Fail Humans" - by Hemant Goswami<br />
  10. erickwidya New Member

    thanks <b>ghemant and satya </b><br /><blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote">Now you are clear and you asked for links then it will be flooded , have a good reading on above links.<hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote">[<img src='/community/emoticons/emotion-4.gif' alt=':p' />] too many link i'm afraid [:I]<br /><br />but i'll read it one by one, maybe miss some <img src='/community/emoticons/emotion-2.gif' alt=':D' /><br />the prev link that u gave me <b>satya</b>, i'm not finished reading it yet and got trouble understanding what it's mean [<img src='/community/emoticons/emotion-5.gif' alt=';)' />]<br />i'll have a good time [B)]<br /><br />thank you for all ur assitance
  11. satya Moderator

    You are always welcome with your doubts and where exactly you're getting confused.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  12. erickwidya New Member

    quote:..where exactly you're getting confused.
    since i'm new at MSSQL 2000, i don't know from where should i start..
    and because of that i'm not planning to start from scratch again when i know what's good to do for developing application with MSSQL 2000

    right now i'm kinda get what i have to do for start not in sequence method, like jumping around in chapter if i can say so..

    so can u guys/girls suggest what i must need to do(that most likely important thing for all of u that need to be concern of) since there's so much aspect in MSSQL that i'm not aware of

    thanks..
  13. satya Moderator

  14. erickwidya New Member

    thanks <b>Satya</b><br />i think i can pass one of those..<br />i'm familiar with SQL query, SPROC but the link at PSC is great..i'll look at it..<br /><br />maybe it's more clear if i say this<br />which aspect do i need to manage when i started involve with MSSQL 2000 beside T-SQL?<br />or maybe not [<img src='/community/emoticons/emotion-5.gif' alt=';)' />]<br /><br />thanks
  15. FrankKalis Moderator

    To get a good understanding of SQL Server 2000, I think it's most useful to understand how and why SQL Server works the way it does, i.e. what is going on behing the scenes when you do this or that operation. In that regard, what about getting "Inside SQL Server 2000" by Kalen Delaney? I guess almost every serious SQL Server user agrees that this book is one of the must-have books.

    --
    Frank Kalis
    Microsoft SQL Server MVP
    http://www.insidesql.de
    Ich unterstütze PASS Deutschland e.V. http://www.sqlpass.de)
  16. satya Moderator

    Oh my bad.. how can I forget the reference about Kalen Delaney's book... good addition by Frank.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  17. ghemant Moderator

    hey Satya , Frank<br />what about 'Admin 911' ?! how do u rank it ?! i think this is also a good book.<br /><br /><br />[<img src='/community/emoticons/emotion-2.gif' alt=':D' />]<br /><br />hsGoswami<br />ghemant@gmail.com<br />"Humans don't have Caliber to PASS TIME , Time it self Pass or Fail Humans" - by Hemant Goswami<br />
  18. satya Moderator

    I heard about that book(reviews from websites) but never got a chance to go through it.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  19. FrankKalis Moderator

    Same here. I know it's from Brian Knight, co-founder of SQL Server Central.com and I think it's mentioned here in the book reviews. However, he didn't send me a review copy yet. [<img src='/community/emoticons/emotion-4.gif' alt=':p' />]<br /><br />--<br />Frank Kalis<br />Microsoft SQL Server MVP<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />Ich unterstütze PASS Deutschland e.V. <a target="_blank" href=http://www.sqlpass.de>http://www.sqlpass.de</a>) <br />
  20. erickwidya New Member

    thanks <b>FrankKalis, Satya, ghemant</b><br /><blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote">To get a good understanding of SQL Server 2000, I think it's most useful to understand how and why SQL Server works the way it does, i.e. what is going on behing the scenes when you do this or that operation. In that regard, what about getting "Inside SQL Server 2000" by Kalen Delaney?<hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br />o yes2..i'll hunt for it immediately <img src='/community/emoticons/emotion-2.gif' alt=':D' /><br /><br />now i got MSSQL 2000 DEVELOPER ed. by Wrox i think..not finished reading it yet, and not through about Security Chapter too [<img src='/community/emoticons/emotion-6.gif' alt=':(' />]<br />well i guess it's my time to learn about it before i ask another question<br /><br />thank you all,<br />erick
  21. ghemant Moderator

    Most welcome <br /><br /><br />[:I][<img src='/community/emoticons/emotion-2.gif' alt=':D' />]<br /><br />hsGoswami<br />ghemant@gmail.com<br />"Humans don't have Caliber to PASS TIME , Time it self Pass or Fail Humans" - by Hemant Goswami<br />

Share This Page