I just do a simple call to a stored procedure with 3 input parameters in ssms,

no output value.

for example I just want to execute sp_WhoIsActive with some input parameters in...

Thanks, how about the counter:

SQL Server: Buffer Manager:Physical reads/sec

Does this mean per second physical read from hard disk or buffer manager?

Thanks

I change the reindex opertion to ola.hallengren solution,

It is amazed to see it saved a lot of time to run the reindex and also didn't show disk or log full...

Thanks, I check with the other network admin, we do that for all SQL services.

By the way , for my workstation developer instance, I use local account, like local system...

Thanks, we don't have clustered servers.

When you say it failed it will roll back, does it give out some information said it has rolled back, or it simply say...

Thanks, although by changing the system file seems a workaround, I prefer to not to change it.

I ends up to restore a database on the same server, then I am...

Grant Fritchey (2/12/2013)

---

An 8gb database? Unless you're running it on a VERY tiny little drive, there's no need to do a differential. Just do a FULL on a daily basis....

Thanks much,

I also read somewhere if using BLOBS, and Data encryption, it is not recommended to use compression backup, anything else?

Thanks

Thanks much, that is good news. Glad to know that.

Thank you, I am concerned a little bit if compression backup is reliable or not since it is compressed, any chance it compressed in error?

Thanks

Thanks much!

I think there are a lot of transactions going each day. It is a software that manages our organization each workstation power management.

We have not used the compression yet, I...

Thanks much.

I checked and currenly the data file is 7.9 GB, the log size is 500 MB with 97% free.

I heard it is not a good practice to shrink log...

Thanks that is good to know. I also read this http://blog.sqlauthority.com/2008/07/03/sql-server-2008-introduction-to-new-feature-of-backup-compression/

It sounds good to enable it when I do upgrades too.

Thanks, it seems there is some downside when doing compression backup, it uses more of resources than regular backup