Showing posts with label perfmon. Show all posts
Showing posts with label perfmon. Show all posts

Sunday, March 11, 2012

Acces to a file that is locked by another process

I am writing a package to process perfmon logs. The issue I have come across is that the perfmon process holds onto the log file and SSIS fails because it wants to exclusive read access. Is there any way of getting SSIS to not take an exclusive read on the file.

I can read the file in notepad fine but not SSIS.

check by changing the isolation level of package by default its serialiazable

Thursday, March 8, 2012

Absent SQL Counters under X64 environment

all,
Am missing SQL counters when I do perfmon from my desktop to SQL 2000 (x64)
database server. Is this due to an incorrect executable running from the
desktop?
thanks.
jl
There is a post on this problem at:
http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=12363
Hope it helps.
"John L" wrote:

> all,
> Am missing SQL counters when I do perfmon from my desktop to SQL 2000 (x64)
> database server. Is this due to an incorrect executable running from the
> desktop?
> thanks.
> --
> jl

Absent SQL Counters under X64 environment

all,
Am missing SQL counters when I do perfmon from my desktop to SQL 2000 (x64)
database server. Is this due to an incorrect executable running from the
desktop?
thanks.
--
jlThere is a post on this problem at:
http://www.sql-server-performance.c...?TOPIC_ID=12363
Hope it helps.
"John L" wrote:

> all,
> Am missing SQL counters when I do perfmon from my desktop to SQL 2000 (x64
)
> database server. Is this due to an incorrect executable running from the
> desktop?
> thanks.
> --
> jl

Absent SQL Counters under X64 environment

all,
Am missing SQL counters when I do perfmon from my desktop to SQL 2000 (x64)
database server. Is this due to an incorrect executable running from the
desktop?
thanks.
--
jlThere is a post on this problem at:
http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=12363
Hope it helps.
"John L" wrote:
> all,
> Am missing SQL counters when I do perfmon from my desktop to SQL 2000 (x64)
> database server. Is this due to an incorrect executable running from the
> desktop?
> thanks.
> --
> jl