For a SQL 2000 server, is it bad to see too many
exec sp_releaseschemalock 1
events in a SQL trace file?
Sql-server – sql 2000 trace : sp_releaseschemalock
profilersql-server-2000
Related Question
- Sql-server – Running a sql server Trace of 1 GB using sqlcmd
- Sql-server – How to upgrade a SQL 2000 Database to SQL 2005 – need confirmation
- Sql-server – Where is this thestery trace going (SQL Server 2000)
- Sql-server – SQL Server 2000 trace file extension
- SQL Server 2000 – How to Upgrade SQL Server Engine
- SQL Server Profiler – Comprehensive SQL Trace Events List
- Sql-server – Modern SQL Profiler against SQL 2000
Best Answer
Since sp_releaseschemalock is an internal stored procedure, under normal circumstances, seeing many of it is not an issue.