Help / SQL Server
SQL Server
Do you offer ASPState database on SQL Servers?
We looked into this thoroughly and found that its a huge security risk as the ASPState database is shared and each application will have (read/write!) access to each other's state...
Run a SQL Query on DatabaseBy default Plesk does not give full access to run most SQL Queries on a database. 2 options exist. 1. Provide us with the SQL Query though we will need to first go through the quer...
SQL Query to find highest CPU usage by databaseWITH CPU_Per_Db AS (SELECT dmpa.DatabaseID , DB_Name(dmpa.DatabaseID) AS [Database] , SUM(dmqs.total_worker_time) AS CPUTimeAsMS FROM sys.dm_exec_query_stats dmqs CROSS APPLY (SELE...
The query has been cancelled because the estimated cost of this queryThe error : The query has been cancelled because the estimated cost of this query (xxxx) exceeds the configured threshold of 600. Contact the system administrator On our shared ho...