hi, will u plz tell me is there is any query for sql server like in oracle we use statspack to see database stats .plz tell me how can we see database stats in sql server . thaxxx
Well, in SQL Server one should use DMV for knowing details about db/server usage: http://msdn2.microsoft.com/en-us/library/ms188754.aspx This link can take you to variety of DMV's avialable in SQL Server 2005.
We are no expert in Oracle. May be if you explain what statspack does, we can point you in SQL server.
SQL Server 2005 Performance Dashboard Reports http://www.microsoft.com/downloads/...0D-7E0C-4730-8204-E419218C1EFC&displaylang=en