You need to include additional fields in profiler to see what ObjectName and TextData (exact...

run sp_whoisactive or sp_who2 to find out what that sessions are doing.

What procedure is on event "RPC Completed" and how much cpu it is using?

Try to execute that procedure yourself.

Take full backup once.

Daily take differential backups and restore them to test after a full backup restore.

Turn "instant file initialization" and backup compression on to speed-up the process.

Your steps to shrink the log file are extremely dangerous with potential risk of losing the db completely. No one should do that.

You could diff backup db, set it to...

Comparison of clustered index table with unindexed heap in this article is not fair, IMHO. Clustered index means we have both data and index. HEAP means we only have data...

Do you truly understand what data recovery means? And what HA means?

SQL HA and DR solution (e.g. mirroring or cluster) is not the only thing you need.

They help to achieve...

How do you copy the data?

With BCP OUT you can dump all tables into files (use -N option to convert all textual fields to unicode while keeping other fields native),...

Gail is right. You will have to restore to two separate databases, each rolled forward to different point-in-time.

You can find out the reason why the log grows (why it is not reused, why the VLF's are not cleared)

from the log_reuse_wait_desc in sys.databases:

select name, log_reuse_wait_desc, recovery_model_desc from sys.databases

If...

If table does not have a clustered index (it's a heap table) and fill factor is default (0 which is the same as 100%) updates that make rows wider will...

High Availability means your database will be available for usage in a very large proportion of the time.

It is measured in percent of uptime or number of nine's, e.g. 99.99%.

Basically...

If your clustering key contains uniqueidentifier and you fill it's value with newid() it will heavily fragment that CL index and make all operations several times slower (especially inserts) than...

Nice article here: http://blog.kejser.org/2011/07/07/the-ascending-column-problem-in-fact-tables-part-two-stat-job/%5B/url%5D

Still - unsupported, so you use it on your own risk.

Are users reporting performance problems and can you reproduce them, as user sees them?

Start with that and WAIT analysis (overall cumulative waits of the system and waits of the currently...

First and most important thing to do is to choose a good clustering key.

Currently your CL key columns are also a primary key columns: idx, nogaji, TkhTransaksi

Your table is partitioned...