HI ,

Can you run the profiler and find out from which hostname the long running quries are hitting .

Thanks Grant\Muthu

I have one more question :

[Memory ]

Pagefaults\Sec : is varying from 60,90,220,2434 like this ??

What is the recomended value [i.e low or high ] . I am new...

HI ,

Thanks for quick response.

I googled for this is issue , in some articles saying the pagelife expectancy value should be low .

i searched , but i didn't...

HI ,

I am having trouble creating a maintenance plan through the GUI, since there appears to be a version mismatch between SQL Server Management Studio and the Database Engine....

HI ,

sorry . I got solution please close the ticket.

Does SQL Server take more memory than the 14GB you allocated?

No , SQL server taking 14 GB ,I am running total server memory and target serevr memory counters in the...

Thank you,

My issue was resolved .

HI Granty ,

The DB utilization goes to 100 % and teh same time we are getting alerts from the site.

By running profiler i found some queries...

HI Eugene,

Thanks for quick reply .

if we want to stor the data in a table nvarchar(max) is correct . But if we want to store the complete...

HI Gila,

please reply to mail pleaseee

This is DB server No other applications are running .

Please see the below figures ::

Max memory seetings : 14 GB out of 16 GB RAM [In SQl server...

hI,

Max memory seetings : 14 GB out of 16 GB RAM [In SQl server management studio]

SQL server :memory Manager [perfmon counter]

Target Server memory: 11,382,584.000

Toatl Server...

Thanks Gila,

Cool , First day of my previous office i faced this issue , but that is DEV environment. i requested them any backup are there . No answer...

Thanks Gila,

You are right. Data is very important.

The main reason why my database goes to suspect mode is server restarted 2 times . Paricular database goes to...

i faced same issue in previous . we have one week back backup for that database . As u mentioned fix the issue with restore with backup...