Default password has not been changed
The admin password is set to its default value, it is recommended that you change it immediately!
You can change this password by logging in, navigating to My -> Account -> Password.
Current admin login:
Username:"[email protected]"
Password:"2Tight2Wiki@"
System Procedures
Overview
System stored procedures are built in procedures that allow you to evaluate various aspect of the database engine, such as running processes, memory usage and health counters.
- CheckpointHealthCounters - Writes the health counters to disk.
- ClearCacheAllocations - Clears the internal memory cache collection. This does not release the memory, but leaves it allocated for further cache operations.
- ClearHealthCounters - Clears the health counters that are tracked by the engine.
- ReleaseCacheAllocations - Releases unused memory from the internal memory cache back to the operating system.
- ShowBlocks - Shows blocks associated with a process.
- ShowBlockTree - Shows all blocked processesand their dependencies.
- ShowCacheAllocations - Shows the cache allocation details.
- ShowCachePartitions - Shows the memory allocations by memory cache partition.
- ShowHealthCounters - Shows the health counters that are tracked by the engine.
- ShowLocks - Shows all locks for all transactions.
- ShowMemoryUtilization - Shows the operating system level memory utilization used by the database engine.
- ShowProcesses - Shows all active processes, their session ID, process ID and various transaction information.
- ShowTransactions - Shows all transactions that are current active.
- ShowVersion - Shows the names and versions of all loaded assemblies.
- ShowWaitingLocks - Shows processes that are currently waiting on locks.
- ShowAggregateFunctions - Displays the list of built-in aggregation functions and their parameters.
- ShowCachePages - Displays information about cached database pages.
- ShowScalarFunctions - Displays the list of built-in scaler functions and their parameters.
- ShowSystemFunctions - Displays the list of built-in system functions and their parameters.
Related
- Home - The home page
- CheckpointHealthCounters - Writes the health counters to disk.
- ClearCacheAllocations - Clears the internal memory cache collection. This does not release the memory, but leaves it allocated for further cache operations.
- ClearHealthCounters - Clears the health counters that are tracked by the engine.
- Exec - Exec is used to execute a stored procedure (system or user created).
- ReleaseCacheAllocations - Releases unused memory from the internal memory cache back to the operating system.
- ShowBlocks - Shows blocks associated with a process.
- ShowBlockTree - Shows all blocked processesand their dependencies.
- ShowCacheAllocations - Shows the cache allocation details.
- ShowCachePartitions - Shows the memory allocations by memory cache partition.