Ygthkb

How can I handle players killing my NPC outside of combat?

"I showed the monkey himself in the mirror". Why is this sentence grammatical?

Do we still track damage on indestructible creatures?

Does it take energy to move something in a circle?

Is it really OK to use "because of"?

Why does alert(0.-5) print -5?

Was there a pre-determined arrangement for the division of Germany in case it surrendered before any Soviet forces entered its territory?

How can find the 2D Voronoi cell area distribution?

When using Volatility with a memory image, what is the Kernel version?

Should a new user just default to LinearModelFit (vs Fit)

Is it legal to point a domain to someone else's ip (website)?

Why are mages sometimes played bot instead of traditional ADCs?

Was Claire Dearing blamed for any of Jurassic World's failings?

Players preemptively rolling, even though their rolls are useless or are checking the wrong skills

Is it possible to rotate the Isolines on a Surface Using `MeshFunction`?

What is a good reason for every spaceship to carry gun on board?

Critique vs nitpicking

The No-Straight Maze

What's the reason that we have a different number of days each month?

How long has this character been impersonating a Starfleet Officer?

Other than edits for international editions, did Harry Potter and the Philosopher's Stone receive errata?

What would be some possible ways of escaping higher gravity planets?

Is the percentage symbol a constant?

why typing a variable (or expression) prints the value to stdout?

Find Source & Details of APL Heap Table Insert

Sybase SQL - Truncation error occurred. Command has been aborted and find CACHE QUALITYSingle DELETE statement deadlocking in Sybase ASESybase ASE find running processbulk copy out huge table on sybase adaptive serverPassing a table name to a stored procedureFind out foreign key reference tableGet extract of Sybase data as INSERT statements, with order considering table dependenciesPermission denied to run set Identity_insert to tableHow to find index details on Temporary tables in SYBASEMonitor source SQL code of inserts into table

0

I have been running system monitor(sysmon) on Sybase ASE 15.7(SP139) on HP-UX(Itanium) with below command:

sp_sysmon "00:10:00"

go

Observed that number of inserts are very high in any time of a day, unable to find the source of it and the details e.g.- table name, database name, program name etc. below is sample output from sysmon in the early morning when there is no load:

Transaction Profile

-------------------



  Transaction Summary             per sec      per xact       count  % of total

  -------------------------  ------------  ------------  ----------  ---------- 

    Committed Xacts                  10.7           n/a        6390     n/a     



  Transaction Detail              per sec      per xact       count  % of total

  -------------------------  ------------  ------------  ----------  ---------- 

  Inserts

    Fully Logged

      APL Heap Table              58665.7        5508.5    35199448     100.0 %

      APL Clustered Table             0.0           0.0           7       0.0 %

      Data Only Lock Table           13.2           1.2        7918       0.0 %

      Fast Bulk Insert                0.0           0.0           0       0.0 %

      Fast Log Bulk Insert            0.0           0.0           0       0.0 %

    Minimally Logged

      APL Heap Table                  0.0           0.0           0       0.0 %

      APL Clustered Table             0.0           0.0           0       0.0 %

      Data Only Lock Table            0.0           0.0           0       0.0 %

  -------------------------  ------------  ------------  ----------  ---------- 

  Total Rows Inserted             58679.0        5509.8    35207373     100.0 %

It looks like inserts are happening in tempdb however these many inserts are a bit bothering, Appreciate to have expert advice on this.

monitoring sybase sybasease

share

asked 6 mins ago

Learning_DBAdminLearning_DBAdmin

12011

add a comment | 

0

I have been running system monitor(sysmon) on Sybase ASE 15.7(SP139) on HP-UX(Itanium) with below command:

sp_sysmon "00:10:00"

go

Observed that number of inserts are very high in any time of a day, unable to find the source of it and the details e.g.- table name, database name, program name etc. below is sample output from sysmon in the early morning when there is no load:

Transaction Profile

-------------------



  Transaction Summary             per sec      per xact       count  % of total

  -------------------------  ------------  ------------  ----------  ---------- 

    Committed Xacts                  10.7           n/a        6390     n/a     



  Transaction Detail              per sec      per xact       count  % of total

  -------------------------  ------------  ------------  ----------  ---------- 

  Inserts

    Fully Logged

      APL Heap Table              58665.7        5508.5    35199448     100.0 %

      APL Clustered Table             0.0           0.0           7       0.0 %

      Data Only Lock Table           13.2           1.2        7918       0.0 %

      Fast Bulk Insert                0.0           0.0           0       0.0 %

      Fast Log Bulk Insert            0.0           0.0           0       0.0 %

    Minimally Logged

      APL Heap Table                  0.0           0.0           0       0.0 %

      APL Clustered Table             0.0           0.0           0       0.0 %

      Data Only Lock Table            0.0           0.0           0       0.0 %

  -------------------------  ------------  ------------  ----------  ---------- 

  Total Rows Inserted             58679.0        5509.8    35207373     100.0 %

It looks like inserts are happening in tempdb however these many inserts are a bit bothering, Appreciate to have expert advice on this.

monitoring sybase sybasease

share

asked 6 mins ago

Learning_DBAdminLearning_DBAdmin

12011

add a comment | 

I have been running system monitor(sysmon) on Sybase ASE 15.7(SP139) on HP-UX(Itanium) with below command:

sp_sysmon "00:10:00"

go

Observed that number of inserts are very high in any time of a day, unable to find the source of it and the details e.g.- table name, database name, program name etc. below is sample output from sysmon in the early morning when there is no load:

Transaction Profile

-------------------



  Transaction Summary             per sec      per xact       count  % of total

  -------------------------  ------------  ------------  ----------  ---------- 

    Committed Xacts                  10.7           n/a        6390     n/a     



  Transaction Detail              per sec      per xact       count  % of total

  -------------------------  ------------  ------------  ----------  ---------- 

  Inserts

    Fully Logged

      APL Heap Table              58665.7        5508.5    35199448     100.0 %

      APL Clustered Table             0.0           0.0           7       0.0 %

      Data Only Lock Table           13.2           1.2        7918       0.0 %

      Fast Bulk Insert                0.0           0.0           0       0.0 %

      Fast Log Bulk Insert            0.0           0.0           0       0.0 %

    Minimally Logged

      APL Heap Table                  0.0           0.0           0       0.0 %

      APL Clustered Table             0.0           0.0           0       0.0 %

      Data Only Lock Table            0.0           0.0           0       0.0 %

  -------------------------  ------------  ------------  ----------  ---------- 

  Total Rows Inserted             58679.0        5509.8    35207373     100.0 %

It looks like inserts are happening in tempdb however these many inserts are a bit bothering, Appreciate to have expert advice on this.

monitoring sybase sybasease

share

asked 6 mins ago

Learning_DBAdminLearning_DBAdmin

12011

sp_sysmon "00:10:00"

go

Transaction Profile

-------------------



  Transaction Summary             per sec      per xact       count  % of total

  -------------------------  ------------  ------------  ----------  ---------- 

    Committed Xacts                  10.7           n/a        6390     n/a     



  Transaction Detail              per sec      per xact       count  % of total

  -------------------------  ------------  ------------  ----------  ---------- 

  Inserts

    Fully Logged

      APL Heap Table              58665.7        5508.5    35199448     100.0 %

      APL Clustered Table             0.0           0.0           7       0.0 %

      Data Only Lock Table           13.2           1.2        7918       0.0 %

      Fast Bulk Insert                0.0           0.0           0       0.0 %

      Fast Log Bulk Insert            0.0           0.0           0       0.0 %

    Minimally Logged

      APL Heap Table                  0.0           0.0           0       0.0 %

      APL Clustered Table             0.0           0.0           0       0.0 %

      Data Only Lock Table            0.0           0.0           0       0.0 %

  -------------------------  ------------  ------------  ----------  ---------- 

  Total Rows Inserted             58679.0        5509.8    35207373     100.0 %

share

asked 6 mins ago

Learning_DBAdminLearning_DBAdmin

12011

share

asked 6 mins ago

Learning_DBAdminLearning_DBAdmin

12011

asked 6 mins ago

Learning_DBAdminLearning_DBAdmin

12011

asked 6 mins ago

Learning_DBAdminLearning_DBAdmin

12011