?????????????????OA?????????????????????????????????????????????????????????????503????????????????

???????????????JBOSS?????????SQL Server 2005 64λ????檔

????????????????????????????JBOSS????????????????????????????JBOSS??????????

ERROR [org.jboss.ejb.plugins.LogInterceptor] TransactionRolledbackLocalException in method: public abstract xxxx xxx()?? causedBy:
org.jboss.util.NestedSQLException: No ManagedConnections available within configured blocking timeout ( 30000 [ms] ); - nested throwable: (javax.resource.ResourceException: No ManagedConnections available within configured blocking timeout ( 30000 [ms] ))
    at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:106)
    at com.adobe.pof.ConnectionWrapper.getConnection(ConnectionWrapper.java:25)
    at com.adobe.pof.ConnectionWrapper.getMetaData(ConnectionWrapper.java:101)
    at com.adobe.pof.POFBean.getAdapter(POFBean.java:120)
    at com.adobe.pof.omapi.POFObjectManagerRemoteBean.getObjectManagerImpl(POFObjectManagerRemoteBean.java:108)
    at com.adobe.pof.omapi.POFObjectManagerRemoteBean.getEnvironment(POFObjectManagerRemoteBean.java:489)
    at sun.reflect.GeneratedMethodAccessor144.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:592)
    at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:683)

????????????????????????????????????????????????30????????Session???????????????503???????????????????????????????????????????????????????????????????????????????????ó?????????

???????????????????????????????????????????????????????T-SQL????????Щ????????

?????????????????????????????????????????????????????????????????????????????session????????

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
SELECT COUNT(*)??request_session_id FROM
(
SELECT DB_NAME(resource_database_id) AS DatabaseName
?? request_session_id
?? resource_type
?? CASE
WHEN resource_type = 'OBJECT'
THEN OBJECT_NAME(resource_associated_entity_id)
WHEN resource_type IN ('KEY'?? 'PAGE'?? 'RID')
THEN (SELECT OBJECT_NAME(OBJECT_ID)
FROM sys.partitions p
WHERE p.hobt_id = l.resource_associated_entity_id)
END AS resource_type_name
?? request_status
?? request_mode
FROM sys.dm_tran_locks l


) AS a
GROUP BY a.request_session_id

????????session id?150????????????4000+???????????sys.dm_tran_locks ????????????????Щ??????key????S??????????Page??????IS??????30??????????????Щ?????????????

??????????????????

????1?????????????????????????????????????????????????????????????????

????2?????4000+??????????????

?????????????????????Profiler?????Session ID????????????????????????????????T-SQL????????????????Select????????巵??????????????δ???????????????д?????????1900?????????????????????????е???????????????????????????????????????????????????????????????????????50????

????4000+?????????????????????????????????????

????????????????????????????????????????????????????????????????????????в??????????????????????????assignment???д???????????????????????????????????????????????

???????kill??Session 150???Drop????????????????????????