P Squared Utilities

The Support Files are usually generated by P Squared applications and contain key data to help the P Squared support team pin point issues and solve problems. If however, the problem is that the P Squared product will not load then you can not generate a Support file.

It also contains the Configuration Tool which can be used to help resolve configuration problems that prevent other programs from starting correctly.

Support File Generator and Configuration Tool (V1.5.1) (2.62MB)

If you are using SQL Server, then you MUST run this tool on the SQL Server itself, and you must have the correct rights to create Backups of the SQL Database.

The Support Files are usually generated by P Squared applications and contain key data to help the P Squared support team pin point issues and solve problems. If however, the problem is that the P Squared product will not load then you can not generate a Support file.

Database Support File Generator (V4.0.2) (14.6MB)

Debug File Deleter

This utility automatically deletes P Squared Debug files that are older than a specified number of days. Debug Files can get quite large so this utility helps to reduce the amount of disk space used.

For example you use the Windows Task Scheduler to run this utility every day at midnight and tell it to delete all Debug Files that are 5 days old or longer.

Debug File Deleter Utility (39kb)

Database Compact/Repair Utility

This utility Compacts and repairs a standard database using the Microsoft Database Engine.

Before running this utility you must make sure that you have closed all software that is accessing the database - it can only work if it has exclusive access to the file.

Database Compact/Repair Utility (24kb)

By default, Microsoft uses Page Level Locking as this is the fastest method. However this can cause problems if one user needs to be altering other information nearby in the same database - say a presenter in the studio editing the first few items in an hour in Studio B while Studio A is playing out the last few items in the previous hour.

As a cautionary note, this setting only "sticks" while the database is open by at least one user. The moment it is closed by all users the setting is lost and has to be re-set. The correct procedure is therefore:

• Close the database in all locations by all users.

• Use this utility to change the mode and leave it running

• Re-open the database using your normal software.

• You can now safely close this utility as there will be at least one connection open elsewhere which will cause the database to remain in the new locking mode.

Note: Myriad v3, Scoop v3, Nexus v1 and the P Squared Directory already use Record Level Locking, so this utility will not change any performance. Users should not use this utility to change the Database Mode of ANY AutoTrack databases as this can result in very slow scheduling performance. In practice this utility is most likely only of use to Myriad v2 users.

Database Locking Utility (35kb)

Soundcard Information Gatherer (37kb)

This little utility converts hard disk size to amount of audio storage space at a range of qualities using either linear or compressed (IMA ADPCM 4:1) formats.

Myriad Disk Space Calculator (32kb)

This utility tells you how much hard drive capacity you will need to log X days at CD quality stereo (linear or compressed) followed by X days at a lower quality of your choosing.

Powerlog v3 Disc Space Calculator (24Kb)

This command line utility allows you to run other applications at specific process priority. You should not use this utility unless directed to by a P Squared support engineer.

Priorities (24Kb)

This utility allows you to monitor TCP traffic by placing it in to the communication chain.

TCP Bounce (76kb)

Note: In most situations, Boot-Stuff is a better solution than Sleeper. See here for more details.

Sleeper (16Kb)

Time Logger (76kb)