Hi Gail,

CPU and Memory Usage:

https://plus.google.com/photos/117684376666431281878/albums/6151216968217621265?authkey=CPX3t8fB64moeg

Hi Greg,

Answer:

- SQL 2000 is from VM the same physical server as SQL 2012.

- this is in-house designed database for local application used.

- Before I restart the server yesterday (9:45am)...

Hi Grant,

Please refer to the query result you asked for at following url:

1st Results:

https://drive.google.com/file/d/0B7H-a08logDcOXczcl9hOXJlMjg/view?usp=sharing

2nd Results:

SELECT *

FROM sys.dm_exec_query_stats AS deqs

CROSS APPLY sys.dm_exec_sql_text(deqs.sql_handle) AS dest

order by total_worker_time desc, execution_count...

Hi Grant,

I will compiled the results you are looking for tomorrow.

Thanks.

We have vendor recommendation to consult Microsoft straight away because usually this kind of problem they do not know how to handle. In our country, we have partner of Microsoft...

if SQL do not use page file, can you explain to me why it eat a lot of the C driver hardisk space. more than 30GB is gone.

Hi Grant,

First of all, I would like to thanks for your effort for trying to help me on this.

Below is the output that you require:

Wait_Stat:

https://plus.google.com/photos/117684376666431281878/albums/6150800120270462785?authkey=CO-p6rzk2OipbA

Query Stat

https://drive.google.com/file/d/0B7H-a08logDcdEY1WmY2bEo2Rlk/view?usp=sharing

No choice. Fixed in one thing is to let the shop floor and warehouse to continue running. While I need more time to get my self understand the book since...

my previous post attached picture with memory usage of 95% (30.2/32GB). The figure stay the same until I went back from work. Now (after 4 hours), I remote in and...

Hi Guys,

I knew that no matter if I pump in more RAM to the new SQL Server, it will just slowly consume it compare to current situation.

For my case, the...

After I adjust the maximum memory as mentioned as above which is 24GB out of my actual machine 32GB, it stay peak at 94 to 95%.

I'm not sure whether this...

Thank you so much for all your advise.

This evening I encounter the same issue happened last week which are shop floor unable to access to one of the database,...

Hi,

Many thanks for your valuable advise. Could you please guide me through the steps to troubleshoot the problems in my environment. I had around 10 databases with 2 super...

before we moved to SQL Server 2012, we are using SQL Server 2000 with only 4GB of RAM. No issue at all and low memory usage. No need to manage...

Oh ya, how can I check if operator complain when they tried to access one of the database and it caused time out. I check another application which access different...