January 11, 2007 at 7:32 am
Hi:
Trying to determine in an index which set is the default for row locking or page locking. In the HELP indicates that that default is ON on both cases, how do I know for sure what my index is set up to?. when I scripted it does not tell me nothing. Please help.
another question regarding space allocated and space used on the database. SQL Server 2000 has the TASKPAD and at least we can determine the space used/allocated/free. In SQL Server 2005 there is no such TASKPAD, I run DBCC CHECKALLOC, but it does not amount to the data used.
I will appreciate your help.
Thanks
January 11, 2007 at 1:50 pm
I didn't get your first question but the second question answer is ..
In Object Explorer, connect to an instance of SQL Server 2005 and then expand that instance
Expand Databases and then click the database to view it.
From the toolbar, click View and then click Summary.
In the Summary pane, click Report.
MohammedU
Microsoft SQL Server MVP
January 12, 2007 at 4:49 am
generally row locking will be the default, but depending upon the query this may change, this is sometimes typical for a secondary integer index for example where a page can hold 4000 odd values, in a scan the optimiser may decide to page lock rather than row lock - this is less likely for a table or wider index. Unless you're having specific problems due to lock escalation and you know what it is you're looking at and why then it's best to leave sql server to handle all this for you.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
January 12, 2007 at 12:46 pm
Read the following articles to get locking mechanism...
SQL Server: Details of Locking
http://www.awprofessional.com/articles/article.asp?p=26890&rl=1
http://msdn2.microsoft.com/en-us/library/ms190615.aspx
MohammedU
Microsoft SQL Server MVP
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply