Collation concept: SQL Server, database, column

The basics: collation is a set of rules governing the use for characters in a language or in an alhabet.

In SQL Server we have Collation on several different levels:

SQL Server level – every time an instance is installed, a collation setting must be specified; the default one is selected from the Windows OS collation setting, but

Continue reading […] Collation concept: SQL Server, database, column […]

 

'Database name' as a delimiting factor for SQL Server perfmon counters

As a further reading after the performance tuning in shared secure environment, I am posting a list of SQL Server perfmon counters which take ‘database name’ as a delimiting parameter.

\SQLServer:Databases(database_name)\Active Transactions

Number of active update transactions for the database.

\SQLServer:Databases(database_name)\Backup/Restore Throughput/sec

Read/write throughput for backup/restore of a database.

\SQLServer:Databases(database_name)\Bulk Copy

Continue reading […] ‘Database name’ as a delimiting factor for SQL Server perfmon counters […]