SQL Server Performance Forum – Threads Archive

how many connection now?

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

hi, very first run sp_helpdb to get the list of system and user’s db and dbid of the same then you can run select count(dbid) from sysprocesses where dbid=yrdbid to check how many users are connected for particular dbid / databse …. HTH [<img src=’/community/emoticons/emotion-4.gif’ alt=’

‘ />][}<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />] Regards. hsGoswami [email protected]

That should be Master..Sysprocesses
Running the Profiler may help you to get these info
Madhivanan Failing to plan is Planning to fail

thanks Madhivanan and ghemant <blockquote 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"></blockquote id="quote">not sure how to use it..can u elaborate more? <blockquote 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 then 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"></blockquote id="quote"> exatcly what i want about security related, can u guys/girls provide any good link? i already search sql-performance but it seem to many articles that involved <img src=’/community/emoticons/emotion-6.gif’ alt=’

‘ /> thanks

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.

thanks satya <blockquote 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"></blockquote id="quote"> sorry if my question not clear.. 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 hope it more clear than before thanks

hi erick, refer the link below : <a href=’www.sqlsecrity.com’ target=’_blank’ title=’www.sqlsecrity.com’>www.sqlsecrity.com</a> <a href=’www.mssqlcity.com’ target=’_blank’ title=’www.mssqlcity.com’>www.mssqlcity.com</a> <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> <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> <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> <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> <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> <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> HTH [<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />][<img src=’/community/emoticons/emotion-2.gif’ alt=’

‘ />][:I] Regards. hsGoswami [email protected] "Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemant Goswami

Erick Now you are clear and you asked for links then it will be flooded [<img src=’/community/emoticons/emotion-2.gif’ alt=’

‘ />], have a good reading on above links. <hr noshade size="1">Satya SKJ Moderator http://www.SQL-Server-Performance.Com/forum</a> <center>This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.</center>

Good time Erick, [:I][<img src=’/community/emoticons/emotion-2.gif’ alt=’

‘ />] Regards. hsGoswami [email protected] "Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemant Goswami

thanks ghemant and satya <blockquote 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"></blockquote id="quote">[<img src=’/community/emoticons/emotion-4.gif’ alt=’

‘ />] too many link i’m afraid [:I] but i’ll read it one by one, maybe miss some <img src=’/community/emoticons/emotion-2.gif’ alt=’

‘ /> the prev link that u gave me satya, i’m not finished reading it yet and got trouble understanding what it’s mean [<img src=’/community/emoticons/emotion-5.gif’ alt=’

‘ />] i’ll have a good time [B)] thank you for all ur assitance

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.

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..

Then you start from beginning as by these links
http://sqlzoo.net/
http://www.w3schools.com/sql/sql_intro.asp
http://www.planet-source-code.com/vb/Tutorial/default.asp?lngWId=5
http://www.databasejournal.com/ 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.

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

‘ />] thanks

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)

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.

hey Satya , Frank what about ‘Admin 911′ ?! how do u rank it ?! i think this is also a good book. [<img src=’/community/emoticons/emotion-2.gif’ alt=’

‘ />] hsGoswami [email protected] "Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemant Goswami

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.

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=’

‘ />] – Frank Kalis Microsoft SQL Server MVP http://www.insidesql.de</a> Ich unterstÃ¼tze PASS Deutschland e.V. <a target="_blank" href=http://www.sqlpass.de>http://www.sqlpass.de</a>)

thanks FrankKalis, Satya, ghemant <blockquote 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"></blockquote id="quote"> o yes2..i’ll hunt for it immediately <img src=’/community/emoticons/emotion-2.gif’ alt=’

‘ /> 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=’

‘ />] well i guess it’s my time to learn about it before i ask another question thank you all, erick

Most welcome [:I][<img src=’/community/emoticons/emotion-2.gif’ alt=’

‘ />] hsGoswami [email protected] "Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemant Goswami

]]>