DBCC PSS with SQL SERVER 2005

Question

DBCC PSS with SQL SERVER 2005

John Cogdell

SSC-Addicted

Points: 420
More actions
December 1, 2006 at 2:08 pm

#171482

The command is listed as a documented command however when I run
dbcc traceon(3604) with no_infomsgs
dbcc pss (0,51) with tableresults
I get:
Incorrect DBCC statement. Check the documentation for the correct DBCC syntax and options.
December 4, 2006 at 8:00 am

This was removed by the editor as SPAM

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply

DBA_2014 Grasshopper Points: 23 More actions · Answer 1

DBCC PSS is available as undocumented DBCC command in SQL 7.0 and 2000. I think its no longer available in 2005.Not sure though....

John Cogdell SSC-Addicted Points: 420 More actions · Answer 2

Its posted on this site that the command is still good. I just haven't found a person that has got it to work.

Thanks for the reply

MohammedU SSCoach Points: 19644 More actions · Answer 3

I read DBCC PSS is still available (undocumented)

But It is not working for me too

MohammedU
Microsoft SQL Server MVP

Balmukund SSCertifiable Points: 6648 More actions · Answer 4

where did you read that its available in SQL 2005?

MohammedU SSCoach Points: 19644 More actions · Answer 5

http://www.norbtechnologies.com/support/articles/article01.asp

MohammedU
Microsoft SQL Server MVP

Balmukund SSCertifiable Points: 6648 More actions · Answer 6

Balmukund

SSCertifiable

Points: 6648

December 4, 2006 at 11:56 pm

#675732

This is from Norb Technologies not from Microsoft.

MarkusB SSC-Dedicated Points: 37370 More actions · Answer 7

If you read the article carefully you see that it's based on Beta2. A lot of things which there working in Beta 2 didn't work in RTM. So I assume the same goes for PSS.

Markus

[font="Verdana"]Markus Bohse[/font]

MohammedU SSCoach Points: 19644 More actions · Answer 8

Most of the time MS will not publish the undocumented details, so you don't find any info from MS.

MohammedU
Microsoft SQL Server MVP

vineet Raut SSC Eights! Points: 813 More actions · Answer 9

I am wondering what are you looking for in the PSS (process Status structure).

This is an internal command used by Microsoft support engineers which I believe would not be of use to you unless u have access to source code .

let me know if you are planning to do any specific thing with this.