I am under so much pressure from my SQL Server DBA, that I am not permitted to query the server until after hours, as the Memory Usage hits 99% when I query the DB. Its a SQL SERVER with 24gb of RAM. He says SQL Queries are holding memory and do not release the memory, and hence it eventually topples over and requires a re-boot to normalize it again. The server run our MIS and has many users logged in, about 200 users at any one time.
I simply cannot believe that I cannot use Qlikview Incremental Load Queries every two hours duringt he day to provide up to date information to my Qlikview users; because of this problem. Has anyone encourntered this ebfore, as I cannto believe SQL do not have a solution for releasing memory etc
Having spoken with my IT Director whom indicated it’s the MIS system, in that they designed it so that it could not be efficiently queried. They have forbidden us to query the DB, as they say they are the only ones whom should do so, and that Crystal Reports are the only way to extract the data!!
An example of the query would be as follows:
SELECT RL_DATE, RL_CUST, Sum(RL_EXCL) as RL_VALUE
FROM RL (NOLOCK)
WHERE RL_ERA <>’’ and RL_DATE between ‘2013-06-01’ and ‘2013-06-30’ and RL_TRAN_TYPE in (0,1) and RL_EXCL <> 0 and RL_JOB_NUM <>’’