Locks and Blocks: process

Showing posts with label process. Show all posts

Monday, March 26, 2012

log files

We have a developer that is requesting access to log file to help with
develpment process,
What if any would be a best log files for them to see ? If I look under
managament and log files there, those don't really look like they would
help..
ThanksI think you have to ask them. "What type of information is it that you wish to see though this "log
file"?".
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Stup88" <Stup88@.discussions.microsoft.com> wrote in message
news:4A9222CC-9897-47D2-BB49-ECA888E21020@.microsoft.com...
> We have a developer that is requesting access to log file to help with
> develpment process,
> What if any would be a best log files for them to see ? If I look under
> managament and log files there, those don't really look like they would
> help..
> Thanks|||What type of info can you see through this log.. I sent them a copy of what
is currently in there and like I thought it wasn't much help.
"Tibor Karaszi" wrote:
> I think you have to ask them. "What type of information is it that you wish to see though this "log
> file"?".
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Stup88" <Stup88@.discussions.microsoft.com> wrote in message
> news:4A9222CC-9897-47D2-BB49-ECA888E21020@.microsoft.com...
> > We have a developer that is requesting access to log file to help with
> > develpment process,
> >
> > What if any would be a best log files for them to see ? If I look under
> > managament and log files there, those don't really look like they would
> > help..
> >
> > Thanks
>|||Which log? You mean the errorlog file? Basically, some startup messages and mostly more severe error
messages produced by the engine. I doubt this is very helpful to a developer...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Stup88" <Stup88@.discussions.microsoft.com> wrote in message
news:12699E90-3007-4038-B9CA-EF95D1DE5737@.microsoft.com...
> What type of info can you see through this log.. I sent them a copy of what
> is currently in there and like I thought it wasn't much help.
> "Tibor Karaszi" wrote:
>> I think you have to ask them. "What type of information is it that you wish to see though this
>> "log
>> file"?".
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://sqlblog.com/blogs/tibor_karaszi
>>
>> "Stup88" <Stup88@.discussions.microsoft.com> wrote in message
>> news:4A9222CC-9897-47D2-BB49-ECA888E21020@.microsoft.com...
>> > We have a developer that is requesting access to log file to help with
>> > develpment process,
>> >
>> > What if any would be a best log files for them to see ? If I look under
>> > managament and log files there, those don't really look like they would
>> > help..
>> >
>> > Thanks
>>sql

log files

Friday, February 24, 2012

Log all updated tables

We have a third party process that runs and updated several SQL tables.
Is there any way to find out what tables are being updated and store it in another table?IF you are running MS-SQL 2000, then use SQL Profiler.

-PatP|||I thought of that but they want this to run all the time. And profiler can cause some overhead. Is there any way to view what's in the transaction log?|||My first thought would be Lumigent Log Explorer (http://www.lumigent.com/products/le_sql.html), but there are options involving triggers that could also do what you've described.

-PatP|||You can take help of server side trace, as the PROFILER is a resource intensive operation.

http://vyaskn.tripod.com/server_side_tracing_in_sql_server.htm & KBA http://support.microsoft.com/?kbid=822853

Monday, February 20, 2012

Locks/Process ID

I have been trying to track down a database problem in which for some reason
when somebody enters in some data into the database it becauses unavailable
for the application. I looked under Locks/Proccess ID and found that one of
the proccess is 'blocking' can somebody elaborate as to what sort of
processes these are and what blocking means? In addition, about 5 minutes or
so later the application can enter in data again and the web site that uses
the database is available.... any ideas? Thank you.Gabe,
We can tell nothing about the process, we do not have the information. About
blocking, the process is blocking a resource (table, index, row, etc.) and
for that reason other processes do not have access to the resource.
See "Understanding and Avoiding Blocking" in BOL for more info.
AMB
"Gabe Matteson" wrote:

> I have been trying to track down a database problem in which for some reas
on
> when somebody enters in some data into the database it becauses unavailabl
e
> for the application. I looked under Locks/Proccess ID and found that one
of
> the proccess is 'blocking' can somebody elaborate as to what sort of
> processes these are and what blocking means? In addition, about 5 minutes
or
> so later the application can enter in data again and the web site that use
s
> the database is available.... any ideas? Thank you.
>
>|||I have posted screenshots of the issue the resource that is blocking says
its the table, index and row. here are the screenshots, thank you for the
help.
http://66.31.179.80/sql/screenshots.doc
"Alejandro Mesa" <AlejandroMesa@.discussions.microsoft.com> wrote in message
news:920757E2-C5E4-4421-8484-D398215531AF@.microsoft.com...[vbcol=seagreen]
> Gabe,
> We can tell nothing about the process, we do not have the information.
> About
> blocking, the process is blocking a resource (table, index, row, etc.) and
> for that reason other processes do not have access to the resource.
> See "Understanding and Avoiding Blocking" in BOL for more info.
>
> AMB
> "Gabe Matteson" wrote:
>|||test
"Gabe Matteson" <gmatteson@.inquery.biz.nospam> wrote in message
news:uNiskn2cFHA.228@.TK2MSFTNGP12.phx.gbl...
> I have posted screenshots of the issue the resource that is blocking says
> its the table, index and row. here are the screenshots, thank you for the
> help.
> http://66.31.179.80/sql/screenshots.doc
> "Alejandro Mesa" <AlejandroMesa@.discussions.microsoft.com> wrote in
message
> news:920757E2-C5E4-4421-8484-D398215531AF@.microsoft.com...
and[vbcol=seagreen]
one[vbcol=seagreen]
minutes[vbcol=seagreen]
>|||Dear Sir,
please run sp_who2 it will let you know which process is blocking
another process.
Regards.
ghemant
---
ghemant's Profile: http://www.msmcse.ms/member.php?userid=2348
View this thread: http://www.msmcse.ms/t-1870545056|||Thank you.
"ghemant" <ghemant.1qtd4p@.no-mx.msmcse.ms> wrote in message
news:ghemant.1qtd4p@.no-mx.msmcse.ms...
> Dear Sir,
> please run sp_who2 it will let you know which process is blocking
> another process.
> Regards.
>
> --
> ghemant
>
> ---
> ghemant's Profile: http://www.msmcse.ms/member.php?userid=2348
> View this thread: http://www.msmcse.ms/t-1870545056
>|||Is there anyway to tell why a process is being blocked?
"ghemant" <ghemant.1qtd4p@.no-mx.msmcse.ms> wrote in message
news:ghemant.1qtd4p@.no-mx.msmcse.ms...
> Dear Sir,
> please run sp_who2 it will let you know which process is blocking
> another process.
> Regards.
>
> --
> ghemant
>
> ---
> ghemant's Profile: http://www.msmcse.ms/member.php?userid=2348
> View this thread: http://www.msmcse.ms/t-1870545056
>|||A process is blocked when a lock cannot be obtained because another session
already has a lock on the requested resource and the requested lock type is
incompatible. Common causes of blocking include long-running transactions
and queries.
You can use DBCC INPUTBUFFER on the blocking spid to see the currently
executing (or last) SQL statement. Use DBCC UPENTRAN to identify the oldest
open transaction. See http://support.microsoft.com/kb/224453/EN-US/ for
detailed information on troubleshooting blocking problems.
Hope this helps.
Dan Guzman
SQL Server MVP
"Gabe Matteson" <gmatteson@.inquery.biz.nospam> wrote in message
news:eTg013VdFHA.2212@.TK2MSFTNGP14.phx.gbl...
> Is there anyway to tell why a process is being blocked?
> "ghemant" <ghemant.1qtd4p@.no-mx.msmcse.ms> wrote in message
> news:ghemant.1qtd4p@.no-mx.msmcse.ms...
>|||their's a tip to avoid blocking , see the below link.
http://www.sql-server-performance.com/blocking.asp
Regards.
ghemant
---
ghemant's Profile: http://www.msmcse.ms/member.php?userid=2348
View this thread: http://www.msmcse.ms/t-1870545056

Locks/Process ID

I have been trying to track down a database problem in which for some reason
when somebody enters in some data into the database it becauses unavailable
for the application. I looked under Locks/Proccess ID and found that one of
the proccess is 'blocking' can somebody elaborate as to what sort of
processes these are and what blocking means? In addition, about 5 minutes or
so later the application can enter in data again and the web site that uses
the database is available.... any ideas? Thank you.Gabe,
We can tell nothing about the process, we do not have the information. About
blocking, the process is blocking a resource (table, index, row, etc.) and
for that reason other processes do not have access to the resource.
See "Understanding and Avoiding Blocking" in BOL for more info.
AMB
"Gabe Matteson" wrote:
> I have been trying to track down a database problem in which for some reason
> when somebody enters in some data into the database it becauses unavailable
> for the application. I looked under Locks/Proccess ID and found that one of
> the proccess is 'blocking' can somebody elaborate as to what sort of
> processes these are and what blocking means? In addition, about 5 minutes or
> so later the application can enter in data again and the web site that uses
> the database is available.... any ideas? Thank you.
>
>|||I have posted screenshots of the issue the resource that is blocking says
its the table, index and row. here are the screenshots, thank you for the
help.
http://66.31.179.80/sql/screenshots.doc
"Alejandro Mesa" <AlejandroMesa@.discussions.microsoft.com> wrote in message
news:920757E2-C5E4-4421-8484-D398215531AF@.microsoft.com...
> Gabe,
> We can tell nothing about the process, we do not have the information.
> About
> blocking, the process is blocking a resource (table, index, row, etc.) and
> for that reason other processes do not have access to the resource.
> See "Understanding and Avoiding Blocking" in BOL for more info.
>
> AMB
> "Gabe Matteson" wrote:
>> I have been trying to track down a database problem in which for some
>> reason
>> when somebody enters in some data into the database it becauses
>> unavailable
>> for the application. I looked under Locks/Proccess ID and found that one
>> of
>> the proccess is 'blocking' can somebody elaborate as to what sort of
>> processes these are and what blocking means? In addition, about 5 minutes
>> or
>> so later the application can enter in data again and the web site that
>> uses
>> the database is available.... any ideas? Thank you.
>>|||test
"Gabe Matteson" <gmatteson@.inquery.biz.nospam> wrote in message
news:uNiskn2cFHA.228@.TK2MSFTNGP12.phx.gbl...
> I have posted screenshots of the issue the resource that is blocking says
> its the table, index and row. here are the screenshots, thank you for the
> help.
> http://66.31.179.80/sql/screenshots.doc
> "Alejandro Mesa" <AlejandroMesa@.discussions.microsoft.com> wrote in
message
> news:920757E2-C5E4-4421-8484-D398215531AF@.microsoft.com...
> > Gabe,
> >
> > We can tell nothing about the process, we do not have the information.
> > About
> > blocking, the process is blocking a resource (table, index, row, etc.)
and
> > for that reason other processes do not have access to the resource.
> >
> > See "Understanding and Avoiding Blocking" in BOL for more info.
> >
> >
> > AMB
> >
> > "Gabe Matteson" wrote:
> >
> >> I have been trying to track down a database problem in which for some
> >> reason
> >> when somebody enters in some data into the database it becauses
> >> unavailable
> >> for the application. I looked under Locks/Proccess ID and found that
one
> >> of
> >> the proccess is 'blocking' can somebody elaborate as to what sort of
> >> processes these are and what blocking means? In addition, about 5
minutes
> >> or
> >> so later the application can enter in data again and the web site that
> >> uses
> >> the database is available.... any ideas? Thank you.
> >>
> >>
> >>
>|||Dear Sir
please run sp_who2 it will let you know which process is blockin
another process
Regards
--
gheman
----
ghemant's Profile: http://www.msusenet.com/member.php?userid=234
View this thread: http://www.msusenet.com/t-187054505|||Is there anyway to tell why a process is being blocked?
"ghemant" <ghemant.1qtd4p@.no-mx.msusenet.com> wrote in message
news:ghemant.1qtd4p@.no-mx.msusenet.com...
> Dear Sir,
> please run sp_who2 it will let you know which process is blocking
> another process.
> Regards.
>
> --
> ghemant
>
> ---
> ghemant's Profile: http://www.msusenet.com/member.php?userid=2348
> View this thread: http://www.msusenet.com/t-1870545056
>|||Thank you.
"ghemant" <ghemant.1qtd4p@.no-mx.msusenet.com> wrote in message
news:ghemant.1qtd4p@.no-mx.msusenet.com...
> Dear Sir,
> please run sp_who2 it will let you know which process is blocking
> another process.
> Regards.
>
> --
> ghemant
>
> ---
> ghemant's Profile: http://www.msusenet.com/member.php?userid=2348
> View this thread: http://www.msusenet.com/t-1870545056
>|||A process is blocked when a lock cannot be obtained because another session
already has a lock on the requested resource and the requested lock type is
incompatible. Common causes of blocking include long-running transactions
and queries.
You can use DBCC INPUTBUFFER on the blocking spid to see the currently
executing (or last) SQL statement. Use DBCC UPENTRAN to identify the oldest
open transaction. See http://support.microsoft.com/kb/224453/EN-US/ for
detailed information on troubleshooting blocking problems.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Gabe Matteson" <gmatteson@.inquery.biz.nospam> wrote in message
news:eTg013VdFHA.2212@.TK2MSFTNGP14.phx.gbl...
> Is there anyway to tell why a process is being blocked?
> "ghemant" <ghemant.1qtd4p@.no-mx.msusenet.com> wrote in message
> news:ghemant.1qtd4p@.no-mx.msusenet.com...
>> Dear Sir,
>> please run sp_who2 it will let you know which process is blocking
>> another process.
>> Regards.
>>
>> --
>> ghemant
>>
>> ---
>> ghemant's Profile: http://www.msusenet.com/member.php?userid=2348
>> View this thread: http://www.msusenet.com/t-1870545056
>|||their's a tip to avoid blocking , see the below link
http://www.sql-server-performance.com/blocking.as
Regards
--
gheman
----
ghemant's Profile: http://www.msusenet.com/member.php?userid=234
View this thread: http://www.msusenet.com/t-187054505

Locks/Process ID

I have been trying to track down a database problem in which for some reason
when somebody enters in some data into the database it becauses unavailable
for the application. I looked under Locks/Proccess ID and found that one of
the proccess is 'blocking' can somebody elaborate as to what sort of
processes these are and what blocking means? In addition, about 5 minutes or
so later the application can enter in data again and the web site that uses
the database is available.... any ideas? Thank you.
Gabe,
We can tell nothing about the process, we do not have the information. About
blocking, the process is blocking a resource (table, index, row, etc.) and
for that reason other processes do not have access to the resource.
See "Understanding and Avoiding Blocking" in BOL for more info.
AMB
"Gabe Matteson" wrote:

> I have been trying to track down a database problem in which for some reason
> when somebody enters in some data into the database it becauses unavailable
> for the application. I looked under Locks/Proccess ID and found that one of
> the proccess is 'blocking' can somebody elaborate as to what sort of
> processes these are and what blocking means? In addition, about 5 minutes or
> so later the application can enter in data again and the web site that uses
> the database is available.... any ideas? Thank you.
>
>
|||I have posted screenshots of the issue the resource that is blocking says
its the table, index and row. here are the screenshots, thank you for the
help.
http://66.31.179.80/sql/screenshots.doc
"Alejandro Mesa" <AlejandroMesa@.discussions.microsoft.com> wrote in message
news:920757E2-C5E4-4421-8484-D398215531AF@.microsoft.com...[vbcol=seagreen]
> Gabe,
> We can tell nothing about the process, we do not have the information.
> About
> blocking, the process is blocking a resource (table, index, row, etc.) and
> for that reason other processes do not have access to the resource.
> See "Understanding and Avoiding Blocking" in BOL for more info.
>
> AMB
> "Gabe Matteson" wrote:
|||test
"Gabe Matteson" <gmatteson@.inquery.biz.nospam> wrote in message
news:uNiskn2cFHA.228@.TK2MSFTNGP12.phx.gbl...
> I have posted screenshots of the issue the resource that is blocking says
> its the table, index and row. here are the screenshots, thank you for the
> help.
> http://66.31.179.80/sql/screenshots.doc
> "Alejandro Mesa" <AlejandroMesa@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
> news:920757E2-C5E4-4421-8484-D398215531AF@.microsoft.com...
and[vbcol=seagreen]
one[vbcol=seagreen]
minutes
>
|||Dear Sir,
please run sp_who2 it will let you know which process is blocking
another process.
Regards.
ghemant
ghemant's Profile: http://www.mswebservertalk.com/member.php?userid=2348
View this thread: http://www.mswebservertalk.com/t-1870545056
|||Thank you.
"ghemant" <ghemant.1qtd4p@.no-mx.mswebservertalk.com> wrote in message
news:ghemant.1qtd4p@.no-mx.mswebservertalk.com...
> Dear Sir,
> please run sp_who2 it will let you know which process is blocking
> another process.
> Regards.
>
> --
> ghemant
>
> ghemant's Profile: http://www.mswebservertalk.com/member.php?userid=2348
> View this thread: http://www.mswebservertalk.com/t-1870545056
>
|||Is there anyway to tell why a process is being blocked?
"ghemant" <ghemant.1qtd4p@.no-mx.mswebservertalk.com> wrote in message
news:ghemant.1qtd4p@.no-mx.mswebservertalk.com...
> Dear Sir,
> please run sp_who2 it will let you know which process is blocking
> another process.
> Regards.
>
> --
> ghemant
>
> ghemant's Profile: http://www.mswebservertalk.com/member.php?userid=2348
> View this thread: http://www.mswebservertalk.com/t-1870545056
>
|||A process is blocked when a lock cannot be obtained because another session
already has a lock on the requested resource and the requested lock type is
incompatible. Common causes of blocking include long-running transactions
and queries.
You can use DBCC INPUTBUFFER on the blocking spid to see the currently
executing (or last) SQL statement. Use DBCC UPENTRAN to identify the oldest
open transaction. See http://support.microsoft.com/kb/224453/EN-US/ for
detailed information on troubleshooting blocking problems.
Hope this helps.
Dan Guzman
SQL Server MVP
"Gabe Matteson" <gmatteson@.inquery.biz.nospam> wrote in message
news:eTg013VdFHA.2212@.TK2MSFTNGP14.phx.gbl...
> Is there anyway to tell why a process is being blocked?
> "ghemant" <ghemant.1qtd4p@.no-mx.mswebservertalk.com> wrote in message
> news:ghemant.1qtd4p@.no-mx.mswebservertalk.com...
>
|||their's a tip to avoid blocking , see the below link.
http://www.sql-server-performance.com/blocking.asp
Regards.
ghemant
ghemant's Profile: http://www.mswebservertalk.com/member.php?userid=2348
View this thread: http://www.mswebservertalk.com/t-1870545056

Monday, March 26, 2012

log files

log files

log files

Friday, February 24, 2012

Log all updated tables

Monday, February 20, 2012

Locks/Process ID

Locks/Process ID

Locks/Process ID

Locks and Blocks

Blog Archive

About Me