We have an application with SQL 2008 R2 SP1 back end. CPU usage gradually goes up through out the day and then gets to 100% and slow down the application. database size
is about 5 GB ; our server has 8 GB of memory and two CPUs .
we have about 40 users .
any method to start troubleshooting this ? is it safe to run "DBCC FREEPROCCACHE" abd clear CPU cache ?
Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder. The folder can be on the local hard drive or on a network share. This batch file will query the SQL server to get the current date & time and wi…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred.
This will be demonstrated using Adobe Premiere Pro CS6.