Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-12-04 : 08:20:54
|
| Sudha writes "HiI'm working on a java EJB project with SQL Server as backend server and Jrun 3.1 as Application server.I would like to know about "spid". Is the spid assigned for each user connection or for each data source configured for Jrun.coz when i see through the SQl Profiler, I see one spid per data source.Please explain as we are looking at the performance issues of our projectThanks SUdha" |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-12-04 : 12:14:34
|
| A spid is for every connection made to the database server. If your app connects multiple times, then you should see multiple spids.Tara |
 |
|
|
|
|
|
SQL Server spid and App server