Grasshopper,

Unfortinately this didn't solve the semaphore issue. . . . .

it is just increasing on some of our servers cuasing a lot of networktimeouts resulting in processes ending / dataloss...

Foxxo,

This problem still excists and no cause can be found.

I Entered this on the Microsoft Helpdesk (we've got platinum support) but they cannot solve this either.

Recentley we where supported by...

Parthipan,

You can use commandline on your server to retrieve (some of the) AD information.

for example -- exec xp_cmdshell 'net group /domain'

stream it into a table...

Joanpardo71,

If you want to use PERFMOM you can stream the measured counters directly to a table within a database.

Extract it from there to create detailed reports on these counters.

Examine the...

Anthony,

I've just noticed this topic and it might be helpfull to you;

http://www.sqlservercentral.com/articles/Development/2862/

BTW the page-sizes are adjustable ONLY by installing SQL server.

Once...

DNA,

Thanks for the comforting thought.....we have several hundreds of nodes showing this problem (randomly).......

GKramer

Ten Centuries,

Better to script it yourself.

By scripting it yourself you will get familiar with the sys-tables and you can extract just what you need.

Store it in a specially designed...

Ten Centuries,

Restore a backup (on a seperate server) and extract the DDL, drop the restored DB and execute the DDL-script to create a new version (on the target server).

Gkramer

The...