import sys
    from PyQt5.QtGui import QIcon
    from PyQt5 import QtCore, QtGui, QtWidgets
    from PyQt5.QtCore import QSize, Qt, QThread
    from PyQt5.uic import loadUi
    from PyQt5.QtWidgets import QDialog, QApplication
    import pyodbc
    from redminelib import Redmine
    from dateutil.relativedelta import relativedelta
    from io import BytesIO
    from PyQt5.QtWidgets import (QApplication, QComboBox, QDialog,
                                 QDialogButtonBox, QFormLayout, QGridLayout, QGroupBox, QHBoxLayout,
                                 QLabel, QLineEdit, QMenu, QMenuBar, QPushButton, QSpinBox, QTextEdit,
                                 QVBoxLayout)
    
 class MyThread(QtCore.QObject):
    
        mysignal1 = QtCore.pyqtSignal()
    
        def __init__(self, parent=None):
            QtCore.QObject.__init__(self, parent)
    
        def run(self):
            self.change_x()
    
        def change_x(self):
            while True:
                print('start')
                application.heavy_job()
                time.sleep(6)
                application.cpu_sql()
      
                self.mysignal1.emit()
    
    
    class MyThread4(QtCore.QObject):
        mysignal = QtCore.pyqtSignal()
    
        def __init__(self, parent=None):
            QtCore.QObject.__init__(self, parent)
    
        def second_work(self):
                print('start signlal')
                # Передача данных из потока через сигнал
                application.index_frag_inf()
    
    
    
    class mywindow(QtWidgets.QMainWindow):
        def __init__(self):
            super(mywindow, self).__init__()
            self.ui = Ui_MainWindow()
            self.server = None
            self.password = None
            self.username = None
            self.database= None
            self.ui = Ui_MainWindow()
            self.ui.setupUi(self)
        try:
            """Создается подключение к серверу"""
            self.conn = conn = pyodbc.connect(
                'DRIVER={ODBC Driver 17 for SQL Server};SERVER=' + self.server + ';DATABASE=' + self.database + ';UID='
                + self.username + ';PWD=' + self.password, autocommit=True)  # запускает соединение с SQL-сервером
            self.cursor = cursor = conn.cursor()  # создается cursor для соединения
            print('connect succcesfull')
        except Exception:
            return
    
            self.worker1 = MyThread()
            self.worker1.moveToThread(self.thread1)
            self.ui.butt_conn.clicked.connect(self.worker1.change_x)
            self.thread1.start()
    
    
    
            self.worker = MyThread4()
            self.worker.moveToThread(self.thread)
            self.ui.startcheckindex.clicked.connect(self.worker.second_work)
            self.thread.start()
    
     self.ui.tableWidget.setColumnCount(6)
            self.ui.tableWidget.setHorizontalHeaderLabels(('сюда передаются столбцы'))
            self.ui.tableWidget.setColumnWidth(0, 100)
            self.ui.tableWidget.setColumnWidth(1, 100)
            self.ui.tableWidget.setColumnWidth(2, 200)
            self.ui.tableWidget.setColumnWidth(3, 400)
            self.ui.tableWidget.setColumnWidth(4, 80)
            self.ui.tableWidget.setColumnWidth(5, 500)
    
    
    
        def index_frag_inf(self):
            self.ui.tableWidget.clearContents()
            self.cursor.execute(""" 
            Здесь длинный запрос с очень долгим выполнением """)
            self.ui.tableWidget.setRowCount(100)
            tablerow = 0
            for index in self.cursor.fetchall():
                self.ui.tableWidget.setItem(tablerow, 0, QtWidgets.QTableWidgetItem(index[0]))
                self.ui.tableWidget.setItem(tablerow, 1, QtWidgets.QTableWidgetItem(index[1]))
                self.ui.tableWidget.setItem(tablerow, 2, QtWidgets.QTableWidgetItem(index[2]))
                self.ui.tableWidget.setItem(tablerow, 3, QtWidgets.QTableWidgetItem(index[3]))
                self.ui.tableWidget.setItem(tablerow, 4, QtWidgets.QTableWidgetItem(index[4]))
                self.ui.tableWidget.setItem(tablerow, 5, QtWidgets.QTableWidgetItem(index[5]))
                tablerow += 1



    def cpu_sql(self):
        self.cursor.execute(""" Запрос из MS SQL""")
        for cpusql in self.cursor.fetchall():
            self.ui.cpupercent.setText(str(cpusql.cpu_sql))


if __name__ == '__main__':
    app = QtWidgets.QApplication([])
    application = mywindow()
    application.show()
    sys.exit(app.exec())