Home
Choose White Background Choose Yellow Background Choose Orange Background Choose Green Background Choose Blue Background
About
GlueText® gluing internet together since 2006

>
Process > Status Structure > PSS >

Glued on 06/13/2008 at 02:15:02 EST

Less Like ThisMore Like This
Clusty Labs
" Once you've entered your search terms, just click "OK" from the full-screen Wii keyboard and Clusty will process your query immediately without needing an additional click on the "Search" button. Point and click with confidence with large target areas for both search results and clusters! . Go play ยป Clusty Cloud . A Clusty Cloud is a tool that webmasters or bloggers can use to instantly visualize a topic using the familiar tag cloud display. What makes the Clusty Cloud unique is that you can create a cloud based on any topic or query - you don't need tags or months of content on a subject to create an interesting cloud. . Clusty Clouds are generated using our search results for the topic you enter. Since the tags you see come from" [1]
Quoted from
http://clusty.com/labs [Published: Dynamic Content on Fri, 13 Jun 2008 06:14:49 GMT] [743 characters, 132 words] [score: 62]
 Less Like ThisMore Like This
Interesting SQL IO information
" There are several different places in which SQL Server reports different input/output (IO) related information: . The physical_io column of the sysprocesses system table. . Informational messages returned in a batch when the STATISTICS IO option is enabled. . The Reads or Writes column of relevant events in a SQL Profiler trace. . Each of these counters report slightly different information. Depending on what you are want to measure, a given counter may be more appropriate to use than another. This article describes what each counter measures so that you can use the information appropriately. . MORE INFORMATION . Each SQL Server connection has an" [2]
Quoted from
geekswithblogs.net/veerji/archive/200... [Published: Dynamic Content on Fri, 13 Jun 2008 06:14:50 GMT] [655 characters, 105 words] [score: 50]
 Less Like ThisMore Like This
KBAlertz.com: (171224) - The Transact-SQL KILL command is used to abruptly end a SQL Server process. Each process is often called a System Process ID (spid). The SQL Enterprise Manager Kill Process button under Current Activity merely sends a Transact-SQL KILL command to the...
" The SQL Enterprise Manager Kill Process button under Current Activity merely sends a Transact-SQL KILL command to the server, so the server-side KILL mechanism is the same in this case. A spid may respond to the KILL command immediately, or after a delay, or not at all. A delayed or non-responsive KILL command can be normal under some conditions. This article discusses how the KILL command works, what these delayed or non-response conditions are, and how to identify them. NOTE: This article discusses a DBCC command (DBCC PSS) that is unsupported, and may cause unexpected behavior. Microsoft cannot guarantee that you can solve problems that result from the incorrect use of this DBCC command. Use this DBCC command at your own r" [3]
Quoted from
kbalertz.com/171224/Understanding-Com... [Published: Dynamic Content on Fri, 13 Jun 2008 06:23:54 GMT] [736 characters, 122 words] [score: 522]
 

Less Like ThisMore Like This
Troubleshooting and Error Messages Guide
" Expand Search Troubleshooting and Error Messages Guide Chapter 3 Error Message Writeups Process Status Structure Errors Process Status Structure Errors. This section contains error messages for the Adaptive Server Process Status Structure (PSS). Error 8601 Severity . . 20 Error message text . Process %d tried to keep the PSS for process %d when it already had the PSS for process %d kept. Explanation . A process is a task being carried out by Adaptive Server. Processes can be in various states such as running or waiting for resources. Processes cease to exist when they complete normally or are terminated with the kill command. For each user process and some system processes, Adaptiv" [4]
Quoted from
manuals.sybase.com/onlinebooks/group-... [Published: Dynamic Content on Fri, 13 Jun 2008 06:14:50 GMT] [691 characters, 113 words] [score: 1020]
 Less Like ThisMore Like This
INF: Understanding How the Transact-SQL KILL Command Works
" NOTE: This article discusses a DBCC command (DBCC PSS) that is unsupported, and may cause unexpected behavior. Microsoft cannot guarantee that you can solve problems that result from the incorrect use of this DBCC command. Use this DBCC command at your own risk. This DBCC command may not be available in future versions of SQL Server. For a list of the supported DBCC commands, see the "DBCC" topic in the Transact-SQL Reference section of SQL Server Books Online. . Back to the top MORE INFORMATION Each database connection forms a row in sysprocesses, sometimes called a spid or System Process ID. In SQL Server terminology, each connection is also ca" [5]
Quoted from
http://support.microsoft.com/kb/171224 [Published: Dynamic Content on Fri, 13 Jun 2008 06:14:50 GMT] [655 characters, 110 words] [score: 170]
 Less Like ThisMore Like This
INF: Differences in STATISTICS IO, SQL Profiler and Sysprocesses IO Counters
" MORE INFORMATION Each SQL Server connection has an associated process status structure (PSS) that maintains connection-specific state information. Each unique server process ID (SPID) in the sysprocesses system table represents a different PSS, and the information in the sysprocesses virtual table is a "view" into this status information. SQL Server distinguishes between physical IO (that is, the number of times that SQL Server actually makes a Win32 system call to read or write a page) and a logical IO (any time SQL Server requests access to a page). The higher-level query processor routines in SQL Server use a mechanism to request logical access to a page. This routine searches to see i" [6]
Quoted from
http://support.microsoft.com/kb/314648 [Published: Dynamic Content on Fri, 13 Jun 2008 06:14:50 GMT] [698 characters, 112 words] [score: 570]
 

Less Like ThisMore Like This
Microsoft Fixes Profiler Event Bug in SQL Server 2000
" The start time for the Audit:Logout Event is recorded when the Process Status Structure (PSS) object is created. So when you view SQL Server Profiler in SQL Server 2000, the start times that are recorded in Profiler are different for the Audit:Login and Audit:Logout Events. You might also see transaction events in Profiler before the Audit:Login Event is recorded. To find out more about this problem and the supported hotfix, read the Microsoft article "FIX: Start times in the SQL Profiler are different for the Audit:Login and Audit:Logout Events in SQL Server 2000" at . . End of Article What servic" [7]
Quoted from
windowsitpro.com/Article/ArticleID/45... [Published: Dynamic Content on Fri, 13 Jun 2008 06:14:51 GMT] [606 characters, 101 words] [score: 190]
 Less Like ThisMore Like This
Print - Microsoft Fixes Profiler Event Bug in SQL Server 2000
" The start time for the Audit:Logout Event is recorded when the Process Status Structure (PSS) object is created. So when you view SQL Server Profiler in SQL Server 2000, the start times that are recorded in Profiler are different for the Audit:Login and Audit:Logout Events. You might also see transaction events in Profiler before the Audit:Login Event is recorded. To find out more about this problem and the supported hotfix, read the Microsoft article "FIX: Start times in the SQL Profiler are different for the Audit:Login and Audit:Logout Events in SQL Server 2000" at . . . . Free Oracle 2 " [8]
Quoted from
windowsitpro.com/articles/print.cfm?a... [Published: Dynamic Content on Fri, 13 Jun 2008 06:14:52 GMT] [598 characters, 101 words] [score: 190]
 Less Like ThisMore Like This
PSS - Packet Switch Services, Print SubSystem, Process Status Structure, Product Support Service
" Quick Menu PSS - Packet Switch Services, Print SubSystem, Process Status Structure, Product Support Service . There may be many popular meanings for PSS with the most popular definition being that of Packet Switch Services, Print SubSystem, Process Status Structure, Product Support Service . Packet Switch Services is not the only word formed from PSS. There are 3 more listed below. More PSS Definitions . We searched our database and could not find a definition other than Packet Switch Services, Print SubSystem, Process Status Structure, Product Support Service for PSS . If you have more information or know of another definition for PSS" [9]
Quoted from
http://www.auditmypc.com/acronym/PSS.asp [Published: Dynamic Content on Fri, 13 Jun 2008 06:15:09 GMT] [644 characters, 103 words] [score: 1050]
 

Less Like ThisMore Like This
Kill sleeping process [Archive] - dBforums
" You can execute the kill command against a sleeping process however the kill must be recognized by the process itself, kill is actually a please commit suicide. In order for the process to recognize the kill it must wake up and see the p_killyourself bit set in the it's PSS (process status structure). Of course, if the process never wakes up........... E Jason Webster jason.webster`@mail.state.ky.us wrote in message news:YJT#$Nc1BHA.216@forums.sybase.com... You can't kill things in their sleep. newbie wrote in message news:FF517317452E53810054C6FE85256B80.00... 6B80@webforums... I have a sleeping dump transaction. Anyway to kill it besides restarting the server? Will it" [10]
Quoted from
www.dbforums.com/archive/index.php/t-... [Published: Dynamic Content on Fri, 13 Jun 2008 06:14:52 GMT] [686 characters, 98 words] [score: 540]
 Less Like ThisMore Like This
Sybase Technical News - Volume 8, Number 5 Newsletter: Database Management - Sybase Inc
" Any process opening or closing a database must do so through this subsystem, which maintains a list of open databases, the server user ID (suid) accessing the database, and other information in memory. The manager also accesses the Process Status Structure (PSS), which is a memory structure associated with each process describing the state of the process and usage of various resources used by the process. . Error 941 is raised when the Database Context Manager encounters a problem in fulfilling a database context change request. . Error 941 occurs with the following states: . Error 941 is due to corruption of the PSS or other memory structures. Action . Shut down and restart Adaptive Server to clear a" [11]
Quoted from
http://www.sybase.com/detail?id=205913 [Published: Dynamic Content on ] [711 characters, 119 words] [score: 500]

References:
  [1]: Quoted from Clusty Labs found at http://clusty.com/labs [Published: Dynamic Content on Fri, 13 Jun 2008 06:14:49 GMT] [743 characters, 132 words]
  [2]: Quoted from Interesting SQL IO information found at http://geekswithblogs.net/veerji/archive/2004/07/30/9037.aspx [Published: Dynamic Content on Fri, 13 Jun 2008 06:14:50 GMT] [655 characters, 105 words]
  [3]: Quoted from KBAlertz.com: (171224) - The Transact-SQL KILL command is used to abruptly end a SQL Server process. Each process is often called a System Process ID (spid). The SQL Enterprise Manager Kill Process button under Current Activity merely sends a Transact-SQL KILL command to the... found at http://kbalertz.com/171224/Understanding-Command-Works.aspx [Published: Dynamic Content on Fri, 13 Jun 2008 06:23:54 GMT] [736 characters, 122 words]
  [4]: Quoted from Troubleshooting and Error Messages Guide found at http://manuals.sybase.com/onlinebooks/group-as/asg1250e/svrtsg/@Generic__BookTextView/49940;pt=15380 [Published: Dynamic Content on Fri, 13 Jun 2008 06:14:50 GMT] [691 characters, 113 words]
  [5]: Quoted from INF: Understanding How the Transact-SQL KILL Command Works found at http://support.microsoft.com/kb/171224 [Published: Dynamic Content on Fri, 13 Jun 2008 06:14:50 GMT] [655 characters, 110 words]
  [6]: Quoted from INF: Differences in STATISTICS IO, SQL Profiler and Sysprocesses IO Counters found at http://support.microsoft.com/kb/314648 [Published: Dynamic Content on Fri, 13 Jun 2008 06:14:50 GMT] [698 characters, 112 words]
  [7]: Quoted from Microsoft Fixes Profiler Event Bug in SQL Server 2000 found at http://windowsitpro.com/Article/ArticleID/45405/ [Published: Dynamic Content on Fri, 13 Jun 2008 06:14:51 GMT] [606 characters, 101 words]
  [8]: Quoted from Print - Microsoft Fixes Profiler Event Bug in SQL Server 2000 found at http://windowsitpro.com/articles/print.cfm?articleid=45405 [Published: Dynamic Content on Fri, 13 Jun 2008 06:14:52 GMT] [598 characters, 101 words]
  [9]: Quoted from PSS - Packet Switch Services, Print SubSystem, Process Status Structure, Product Support Service found at http://www.auditmypc.com/acronym/PSS.asp [Published: Dynamic Content on Fri, 13 Jun 2008 06:15:09 GMT] [644 characters, 103 words]
  [10]: Quoted from Kill sleeping process [Archive] - dBforums found at http://www.dbforums.com/archive/index.php/t-325383.html [Published: Dynamic Content on Fri, 13 Jun 2008 06:14:52 GMT] [686 characters, 98 words]
  [11]: Quoted from Sybase Technical News - Volume 8, Number 5 Newsletter: Database Management - Sybase Inc found at http://www.sybase.com/detail?id=205913 [Published: Dynamic Content on ] [711 characters, 119 words]



Instead of you, GlueText checked out (or skipped) 291 web pages and selected the 11 shown above as something that might be helpful for your research. GlueText have just saved you about 47 minutes of your life that you would've otherwise wasted sifting through information pollution on the internet.
Also glued for you by GlueText®:
  a    b    c    d    e    f    g    h    i    j    k    l    m    n    o    p    q    r    s    t    u    v    w    x    y    z    other  
                                Up LevelView document(Process)
                                Type   TopicRelative
Popularity
                                GlueText1.
63
                                GlueText2.
48
                                GlueText3.
44
                                GlueText4.
38
                                GlueText5.
32
                                GlueText6.
32
                                GlueText7.
24
                                GlueText8.
24
                                GlueText9.
22
                                GlueText10.
21
                                Prev   PNext
Not there? Try searching related GlueText pages via Google






© 2006-2008 GlueText® Inc. v0_0_7
GlueText is a USPTO & CIPO Registered TradeMark
GlueText is a patent pending technology in USA and Canada.