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
  Using pyodbc&pandas to load a Table data to df tester_V 3 747 Sep-09-2023, 08:55 PM
Last Post: tester_V
  How to detect abnormal data in big database python vanphuht91 5 1,064 Jun-27-2023, 11:22 PM
Last Post: Skaperen
  Database that can compress a column, or all data, automatically? Calab 3 1,120 May-22-2023, 03:25 AM
Last Post: Calab
  Basic SQL query using Py: Inserting or querying sqlite3 database not returning data marlonbown 3 1,304 Nov-08-2022, 07:16 PM
Last Post: marlonbown
  pyodbc gmerritt 8 2,799 Feb-21-2022, 07:21 PM
Last Post: gmerritt
  I need help parsing through data and creating a database using beautiful soup username369 1 1,682 Sep-22-2021, 08:45 PM
Last Post: Larz60+
  SaltStack: MySQL returner save less data into Database table columns xtc14 2 2,115 Jul-02-2021, 02:19 PM
Last Post: xtc14
  Looping to read data in database CEC68 1 1,678 Sep-24-2020, 08:54 PM
Last Post: scidam
  saving data from text file to CSV file in python having delimiter as space K11 1 2,355 Sep-11-2020, 06:28 AM
Last Post: bowlofred
  from global space to local space Skaperen 4 2,269 Sep-08-2020, 04:59 PM
Last Post: Skaperen

Forum Jump:

User Panel Messages

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