March 27, 2007 at 8:26 am
I´m monitoring some applications in Sql Server 2005, I found a lot of Locks in processes/queries, then I decided to use the command (ALTER DATABASE DBNAME SET ALLOW_SNAPSHOT_ISOLATION ON ), How can I know that this database DBNAME is using the set command? , Where I can see this command, if is set for database DBNAME?, How can I get it this information?.
March 27, 2007 at 10:28 am
Your question isn't entirely clear...
SP_WHO2 or use the Activity Monitor.
March 27, 2007 at 10:46 pm
From BOL:
USE
AdventureWorks;
GO
-- Check the state of the snapshot_isolation_framework
-- in the database.
SELECT
name, snapshot_isolation_state,
snapshot_isolation_state_desc
AS description
FROM
sys.databases
WHERE
name = N'AdventureWorks';
GO
USE
master;
GO
ALTER
DATABASE AdventureWorks
SET ALLOW_SNAPSHOT_ISOLATION ON;
GO
-- Check again.
SELECT
name, snapshot_isolation_state,
snapshot_isolation_state_desc
AS description
FROM
sys.databases
WHERE
name = N'AdventureWorks';
GO
MohammedU
Microsoft SQL Server MVP
March 28, 2007 at 10:30 am
Hi Andrew, thank you by your attention.
When I use SP_WHO2 procedure or Activity Monitor, it isn't show me, that database XXXX is using ALLOW_SNAPSHOT_ISOLATION ON, after have been used ALTER DATABASE command.
Ian.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply