CODEWITHSUNDEEP
databasesybase
Bob
Bob

Reputation: 387

Sybase: what device names does a database use?

Does anyone know how I can query the database to find what devices a database uses?

There is the sysdatabases table and the sysdevices table but I don't know how to link them

Anyone know?

Upvotes: 1

Views: 5358

Answers (2)

PerformanceDBA
PerformanceDBA

Reputation: 33708

1 Just a note re your first question. If you USE database first, you will get even more detail in the report.

2 Do you still need the second question answered, how to link sysdatabase and sysdevices, as in, are you writing queries against the catalogue ? If so, I need your ASE version, the answers are different.

Upvotes: 1

AdamH
AdamH

Reputation: 1351

The best way is to run sp_helpdb against the database you're interested in:

1> sp_helpdb tempdb2
2> go
... other stuff here...
device_fragments               size          usage                created                   free     kbytes
------------------------------ ------------- -------------------- ------------------------- ----------------
tempdb2data                        2048.0 MB data only            Dec 17 2008 11:42AM                2086568
tempdb2log                         2048.0 MB log only             Dec 17 2008 11:42AM       not applicable
tempdb2log                         2048.0 MB log only             Dec 17 2008 11:42AM       not applicable
tempdb2data                        2048.0 MB data only            Dec 17 2008 11:43AM                2088960
tempdb2log                         4096.0 MB log only             Dec 17 2008 11:44AM       not applicable

--------------------------------------------------------------
log only free kbytes = 8355836

Upvotes: 1

Related Questions