SQL Server Performance

how to get the number of blocks in a table

Discussion in 'SQL Server 2005 Performance Tuning for DBAs' started by avdhoot_saple, Apr 26, 2007.

  1. avdhoot_saple New Member

    Hi, I was wondering if I can extract the information pertaining to number of blocks (used blocks) in a user table. Is this information stored in any of the system tables. I am able to get this information in Oracle, but could not find it in sql server.
    thanks!






  2. Adriaan New Member

    Search Books Online for discussions of database architecture. No idea if it's just the different lingo, or perhaps the (perceived) overcomplicated nature of Oracle.
  3. MohammedU New Member

    If you are looking number of blocks on the disk, I don't think there is any way to get it in sql server.

    What is your requirement?

    MohammedU.
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.

Share This Page