Webcast "SQL Server par la pratique pour les utilisateurs expérimentés", module 2 Bases de données

  • Article

 

/* Partie 1*/

 

select * from sys.databases

select

* from LOCAL.Ventes.dbo.Vendeurs

/* ------------------------------------------- */

EXEC

sp_spaceused

/* ------------------------------------------- */

/* Partie 2*/

DBCC

SQLPERF (LOGSPACE)

backup

database Ventes to "Disque C"

backup

log Ventes to "Disque C"

/* ------------------------------------------- */

/* Vue catalogue, de type serveur */

select

* from sys.databases

GO

/* Vue catalogue, de type base de données */

use

Ventes

select

* from sys.database_files

GO

/* Vue dynamique, globale */

select

* from sys.dm_os_wait_stats

order

by wait_time_ms desc

/* Vue dynamique, sur une base de données */

USE

AdventureWorks;

GO

SELECT

* FROM sys.dm_db_partition_stats;

GO

USE

AdventureWorks;

GO

SELECT

* FROM sys.dm_db_partition_stats

WHERE

object_id = OBJECT_ID('HumanResources.Employee')

GO

USE

AdventureWorks;

GO

SELECT

SUM(used_page_count) AS total_number_of_used_pages,

SUM (row_count) AS total_number_of_rows

FROM

sys.dm_db_partition_stats

WHERE

object_id=OBJECT_ID('HumanResources.Employee') AND (index_id=0 or index_id=1);

GO