I want to find out if my server has IO bottlenecks and also Memory pressure. What information do i need to provide here? Thanks

Thank you for the help, everyone. This is my first post here and feel grateful to get all your help.

Can't find the option of 'optimize for ad hoc workloads', here is the error message

The configuration option 'optimize for ad hoc workloads' does not exist, or it may be an...

Yes, I did set the max memory. Thank you very much for the clarification, George.

SQL Server is using around 1.6 GB of memory and CACHESTORE_SQLCP uses almost 0.8GB. Do...

the server has a total of 3.25 GB memory. if turn on the /3gb, will it leave too less memory for OS?

Thank you, George. adding /3g switch in the boot.ini file will require a server reboot, right? application team may not want to reboot the server. I will let them know...

I don't see blocking transactions on the server. can you help me take a look at the dbcc memeorystatus result above?

Yes, this is 32bit server. I don't have /PAGE /3GB in boot.ini file. "Lock page in memory" is not given access to sql server service account.

Here is the DBCC...