Sunday, July 19, 2009

Flushing Expired Session Stat Data from SSP Database

Sometime Sharepoint performance suffers because of the expired session state data stored in SSP database.Periodically, it will be necessary to flush data from the SSP database. The data is located in the SSP database in a table named ASPStateTempSessions. Truncating this database removes any expired sessions from the table. To truncate this table, run the following command from SQL Query Analyzer:
truncate table ASPStateTempSessions

No comments: