Python Forum
Get database used data space from pyodbc
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Get database used data space from pyodbc
#1
I need to get 'used data space' of database. I decided to use sp_spaceused. I am using python 3 and pyodbc My code:
        query = '''
CREATE TABLE SpaceUsed (
     TableName sysname
    ,NumRows BIGINT
    ,ReservedSpace VARCHAR(50)
    ,DataSpace VARCHAR(50)
    ,IndexSize VARCHAR(50)
    ,UnusedSpace VARCHAR(50)
    ) 
INSERT INTO SpaceUsed 
EXEC sp_msforeachtable @command1=\'exec sp_spaceused ''?''\'

SELECT 
sum(CONVERT(int,REPLACE(DataSpace,' KB','')) ) as SUM
FROM SpaceUsed
    '''

    db = pyodbc.connect(dsn2)
    curs = db.cursor()
    curs.execute(query)
    actual_size = curs.fetchall()[0][0]
It throws an error:
Error:
actual_size = curs.fetchall()[0][0] pyodbc.ProgrammingError: No results. Previous SQL was not a query.
Questions:

1. How to fix it?
2. What select statement could I use instead of stored procedure to get 'used data space'?
Thanks
Reply
#2
Well ... please disregard my question.
I realized that I have check just simply the database size and don't need to run stored procedure.
Hence it's not relevant for me anymore.
Thanks for advice anyway ..
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  How to space data on x axis m_kdch 0 358 May-05-2025, 12:55 PM
Last Post: m_kdch
  Python script to extract data from API to database melpys 0 1,131 Aug-12-2024, 05:53 PM
Last Post: melpys
  Using pyodbc&pandas to load a Table data to df tester_V 3 3,221 Sep-09-2023, 08:55 PM
Last Post: tester_V
  How to detect abnormal data in big database python vanphuht91 5 2,586 Jun-27-2023, 11:22 PM
Last Post: Skaperen
  Database that can compress a column, or all data, automatically? Calab 3 2,300 May-22-2023, 03:25 AM
Last Post: Calab
  Basic SQL query using Py: Inserting or querying sqlite3 database not returning data marlonbown 3 3,394 Nov-08-2022, 07:16 PM
Last Post: marlonbown
  pyodbc gmerritt 8 5,386 Feb-21-2022, 07:21 PM
Last Post: gmerritt
  I need help parsing through data and creating a database using beautiful soup username369 1 2,438 Sep-22-2021, 08:45 PM
Last Post: Larz60+
  SaltStack: MySQL returner save less data into Database table columns xtc14 2 3,144 Jul-02-2021, 02:19 PM
Last Post: xtc14
  Looping to read data in database CEC68 1 2,450 Sep-24-2020, 08:54 PM
Last Post: scidam

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020