Hi Jenda,

Yes it is possible, I think in addition trying to monitor tempdb where tables are created and dropped on the fly it is going to happen consistently.

I think we...

Hi Skyline,

It should be fine, but if other files or operations are being included then it is probably best to filter them out at some point.

Ed

Hi Jason,

Changing to a BIGINT shouldn't cause any corruption - I will make the changes myself to the article.

If you are getting IO sizes of 256 then it probably means...

A ha yes of course, i'll submit a change to the article at some point.

also if you want to see which of the connections are actually doing something then run this query:

select * from sys.sysprocesses where kpid 0

ed

It is normally best to leave them. It is quite expensive for applications to create connections to sql so they generally have a pool of connections to use, if...

Thanks Scott - using DTLoggedExec actually works so I don't know what is wrong but I will just use that, plus as well as working the output is about a...

It changes to sleeping when it has nothing to do - generally (and this is quite a massive generalization) you want sleeping connections.

Do you have to use a function? If not you can use the query I posted above to generate the file.

How about using ROW_NUMBER and adding it to COUNT(*), it isn't terribly pretty but:

SELECT 'Filename_' + CAST((SELECT COUNT(*) FROM #ListOfFiles) + ROW_NUMBER() OVER (ORDER BY filename) AS VARCHAR(MAX)) FROM #ListOfFiles

Ed

To find out which process is using the cpu, add the counters "Process\ID Process\sqlservr.exe*"

Each instance has an identifier so if you have three instances you will have "sqlservr", "sqlservr#1", "sqlservr#2"...

Hi Scott, Thanks for the reply.

OK so I have taken the config file setting out of the package and now it isn't trying to use any dtsconfig at all -...

To get an accurate picture of what is using your cpu you need to use perfmon, Processor\% Processor Usage\All Instances (I normally don't bother to add _Total) and Process\%Processor Usage\All...

From the registry keys involved it looks like the sqlclr - but on my system when I start the sqlclr it doesn't try to use those keys.

Do you have the...

Can you post the process monitor result when you set this filter:

process name = sqlservr.exe

result = Access Denied

and then start sql.

ed