Many users have been experiencing slowness. I just start looking at Activity Monitor and these 2 numbers alert me.

Other SQL Servers (same version) all have the min server memory setting changed to 1 GB, that's why I wonder if I should change mine too.

One more question, this...

How should I check if Parallelism is happening? Thanks.

I have index rebuild twice a week and statistics update 4 times a week. Looks like the high CPU usage slow down the database access, but how come i find...

I don't know if the application close connection properly. I should talk to the application owner, or there is way to find out from sql server side?

When I ran sp_who2, the LastBatch column shows the date when we reboot the server.

So there is nothing I should do?

No, I didn't make any changes to the server configuration. The database is online, but the checkpoint process uses 171710191 CPUTime, 12279947 DiskIO, which makes me concerned.

Thanks, George. I will talk to our system admin. but at the same time, since all the failed logins are recorded in the Error Logs, which makes it grows fast....

Run DBCC CHECKDB on the user database? I just wonder why the error message refers to the tempdb.mdf file.

Thank you, Sean. It works now. I just need to grant the Alter permission to the table.

I have a trigger on a table, the trigger delete records from another table. I need to grant a permission to a user who can turn on/off the trigger. I...

This is a clustered server. There are lots of databases on the server. Every once a while they ask me to add some databases up there in order to save...

Thank you, IgorMi. Since PLE is just one of performance counters. Do I need to look at other performance counter to determine the memory issue? Or as long as PLE...

here is the result from the query, How should I interpret it? Thanks.

NodePageLifePageLife_SBufferPool_PagesBufferPool_MiBBufferPool_MiB_S

12:08:19436995359046 41867.547 ...