how to solved server error which gets entire server down

See more:

C#

ASP.NET

SQL

server

my application is not running due to server problem..
when I contact my hosting provider he send me following message..
so plz help me how to solve it... Is it solved by code side or any other solution??




utilizing more than 90% of MS SQL load and this cause the entire server to get down. As per our terms of service all the shared hosting accounts are allowed to utilize the maximum of 20% CPU load and that too should not exceed continuously for more than 90 seconds, and hence we suspended this domain for violating our terms of service and the detailed information of queries which took heavy load are as below for your reference,



select * from dbo.ril_fosacct

SELECT * FROM [dbo].[ril_fosacct] WHERE [createddate]<=@1

SELECT
SCHEMA_NAME(sp.schema_id) AS [Schema],
sp.name AS [Name],
CASE WHEN sp.type = N'P' THEN 1 WHEN sp.type = N'PC' THEN 2 ELSE 1 END AS [ImplementationType],
CAST(OBJECTPROPERTYEX(sp.object_id,N'ExecIsQuotedIdentOn') AS bit) AS [QuotedIdentifierStatus],
CAST(OBJECTPROPERTYEX(sp.object_id,N'ExecIsAnsiNullsOn') AS bit) AS [AnsiNullsStatus],
CAST(CASE WHEN ISNULL(smsp.definition, ssmsp.definition) IS NULL THEN 1 ELSE 0 END AS bit) AS [IsEncrypted],
NULL AS [Text],
CAST(
case
when sp.is_ms_shipped = 1 then 1
when (
select
major_id
from
sys.extended_properties
where
major_id = sp.object_id and
minor_id = 0 and
class = 1 and
name = N'microsoft_database_tools_support')
is not null then 1
else 0
end
AS bit) AS [IsSystemObject],
sp.object_id AS [ID],
CAST(ISNULL(spp.is_auto_executed,0) AS bit) AS [Startup],
ISNULL(smsp.definition, ssmsp.definition) AS [Definition]
FROM
sys.all_objects AS sp
LEFT OUTER JOIN sys.sql_modules AS smsp ON smsp.object_id = sp.object_id
LEFT OUTER JOIN sys.system_sql_modules AS ssmsp ON ssmsp.object_id = sp.object_id
LEFT OUTER JOIN sys.procedures AS spp ON spp.object_id = sp.object_id
WHERE
(sp.type = @_msparam_0 OR sp.type = @_msparam_1 OR sp.type=@_msparam_2)
ORDER BY
[Schema] ASC,[Name] ASC