Comments (3)
needs pssdiag capture
from sqlnexus.
Currently PSSDiag, does not tell us how big is database..?
Can we include this important info...?
Chirag Shah (MSFT)
from sqlnexus.
You can pull database size using following query:
select * from [dbo].[tbl_SPHELPDB] where dbid>0
Query following table to get file level detail
select * from [dbo].[tbl_DatabaseFiles]
from sqlnexus.
Related Issues (20)
- Fixes issue with PowerBi Performance Report that does not display many of the charts from an FCI instance HOT 2
- Generate Best Practice/Analysis Summary warning for Common Criteria Compliance. HOT 1
- Add rowsets to be able to import In-Memory OLTP (XTP) DMV outputs from SQL_LogScout HOT 1
- Import the systeminfo file from SQL LogScout and Pssdiag - add XML rowset HOT 3
- Add new XML rowsets to SQL Nexus for In-memory /plan cache
- Workingset Trimming Report not working HOT 4
- dm_db_stats_properties did not pulled by the Nexus when import from logscout HOT 3
- Provide option to Minimize Relog.exe window when processing Permfon BLG files HOT 2
- Add REDO_THREAD_PENDING_WORK to ignorable wait types in reports HOT 2
- Some Importer options aren't "saved" despite "Save my options" being enabled HOT 2
- Consider importing SQLAssessment API output from SQL LogScout and to enable firing Best practices alerts on them HOT 2
- Disk IO Analysis Rule is creating false warnings for single spike HOT 1
- Create an Import option to exclude/ignore SQL LogScout data from being imported by RML Utilities HOT 1
- Add rowsets for import for DbMail scripts from SQL LogScout HOT 1
- Different values between Huge Memory Grant Alert and actual Memory Grant Report HOT 5
- Server Name and version information fields exists on the header of some reports but it is always empty.
- Add some wait types to ignorable list so they don't show up in bottleneck analysis report: CHECKPOINT_QUEUE, PARALLEL_REDO_WORKER_WAIT_WORK, QDS_ASYNC_QUEUE, PWAIT_EXTENSIBILITY_CLEANUP_TASK
- Create a Rowset editor/creator to facilitate adding new rowsets to SQL Nexus for importing HOT 1
- Refactor Nexus to use Microsoft.Data.SqlClient HOT 2
- Create a rowset to import Environmental variables collection in a table HOT 2
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from sqlnexus.