lsuse.com

SQL Server Solutions, Datamanagement

Skip to content
  • Home
  • SQL Versions List
  • Maintenance Solutions
  • Photography
lsuse.com

Determine the Uptime of a SQL Server Instance

SELECT sqlserver_start_time
FROM sys.dm_os_sys_info;

 

This entry was posted in Geen categorie on 31 August 2017 by Demas Jaring.

Post navigation

← Who Filled the Tempdb? SQL Server Generate 100% CPU query →

Recent Posts

  • CompressionSavingsEstimate
  • Generate Dummy Data
  • Generate script – enable query store for each database
  • Capture last login datetime per database
  • Querying the Query Store DMVs Directly to find missing indices
  • Query machine and instance information
  • The maximum values for an integer
  • Login Failed CEIP SQLTELEMETRY
  • Get First and Last day of a week
  • SCOM query – get DISK and CPU info

Tags

  • Batch update
  • Batchupdate
  • CPU Load
  • DatabaseSize
  • filesize
  • PossibleAutoGrowthMB
  • SCOM
  • Security
  • SpaceBeforeAutoGrow
  • SpaceUsed
  • SQL Batch update
  • SSIS
  • SSIS Catalog Server Role
  • SSRS
  • Tuning
  • while loop
  • whileloop

Archives

  • July 2022
  • June 2022
  • April 2022
  • March 2022
  • February 2022
  • October 2021
  • July 2021
  • June 2021
  • March 2021
  • January 2021
  • December 2020
  • November 2020
  • October 2020
  • September 2020
  • July 2020
  • February 2020
  • November 2019
  • August 2019
  • July 2019
  • May 2019
  • April 2019
  • February 2019
  • January 2019
  • December 2018
  • October 2018
  • September 2018
  • April 2018
  • March 2018
  • December 2017
  • November 2017
  • August 2017
  • July 2017
  • May 2017
  • March 2017
  • February 2017
  • January 2017
  • December 2016
  • November 2016
  • October 2016
  • September 2016
Proudly powered by WordPress