Search this forum:
Search
You are not authorized to create a new topic
Page 1 of 212 > >>
Topics
 Replies
 Views
 Last Post
0 Replies and 57 Views SQL (performance) Monitoring Tools  57  0 Started by  Paul Fijma Monitoring, baselining, measure trend and watching and alerting on events i use the ssms (SQL Studio) and powershell (v5) on server 2012...2019. during my career i have used some great tools like New Relic, System Center Operations Manager (SCOM), Heroix, Spotlight, and some others. Here are some free (limited in some ways) tools to use: SQLGrease - http://www.sqlgrease.com - free to use with some interesting limitations. Spotlight Cloud - http://www.spotlightcloud.io/pricing - basic is...
0 57
30 Apr 2020 08:55 AM
0 Replies and 75 Views MSSQL Query TimeOut research  75  0 Started by  Paul Fijma to troubleshoot query timeout issues start with this article https://blogs.msdn.microsoft.com/docast/2018/10/12/troubleshooting-query-timeouts-in-sql-server/ links to the tools: https://github.com/Microsoft/DiagManager https://github.com/Microsoft/SqlNexus
0 75
27 Feb 2020 08:47 AM
1 Replies and 72 Views Effective Database Maintenance  72  1 Started by  Paul Fijma A good article about tips for Effective Database Maintenance by Paul S. Randal: http://docs.microsoft.com/en-us/previous-versions/technet-magazine/cc671165(v=msdn.10) for me effective the order is to do the following: - full backup once every night, with verify - log backups every 5 minutes (to the cloud) with verify - at the end of the day i do max. 2 hour defrag on databases, during the most silent time. ( 2 hour is arbitrary determined, after a check on times needed average in a f...
1 72
by  Paul FijmaJump to last post
24 Feb 2020 01:55 PM
1 Replies and 104 Views Backup How-it-works  104  1 Started by  Paul Fijma Article about backup and how it.. actually works etc.: http://www.sqlshack.com/understanding-sql-server-backup-types/
1 104
by  Paul FijmaJump to last post
24 Feb 2020 01:42 PM
1 Replies and 79 Views Find Missing Index  79  1 Started by  Paul Fijma SQL Scripts: How To Find Missing Indexes (Posted on June 5, 2018 by Eric Cobb) One of the really cool things that SQL Server does is keep up with index statistics behind the scenes. It knows how an index has been used, how often it is used, or if it is even being used at all. But SQL Server doesn’t just monitor the indexes that you currently have, it even keeps up with statistics for indexes that it wishes you had! What Are Missing Indexes When SQL Server is processing a query, it will s...
1 79
by  Paul FijmaJump to last post
21 Jan 2020 10:11 AM
You are not authorized to create a new topic
Page 1 of 212 > >>