Re: SQL Server 2008 caching
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Fri, 8 Aug 2008 07:07:45 +0000 (UTC)
Manoj saini (tomksaini@xxxxxxxxx) writes:
I need to give one functionality in my application as applicationl lock.
If my databsae is get lock at the time of backup, i need to give a
message to user that daatbse has been locked and ask him to log out.
This application is in Dot net2005. Before db lock , i set one parameter
in table and read this table every min with timer. if parameter is set
then i give message to user.
But to hit the DB every min is not good solution.
Pls help he, how i can avoid hit on dataabse
Why would the user have to log out when you do a backup in the first place?
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.
- References:
- SQL Server 2008 caching
- From: Manoj saini
- SQL Server 2008 caching
- Prev by Date: SQL Server 2008 caching
- Next by Date: Re: select blocking sessions t-sql
- Previous by thread: SQL Server 2008 caching
- Next by thread: Re: SQL Server 2008 caching
- Index(es):
Relevant Pages
|
