Our Database in sql server 2008 r2 goes down becoz of more insert and update statement executing in each minute , so that web site opening very slow.
Actually we have GPS Tracking system ( website ) in asp.net , more than 3000 devices send data each device sent his location each minute its mean each minute
it mean each minute 3000 rows inserted and 3000 rows updated.
so this is the reason of slowness of website.
Is any thing or configuration to keep sql server processing of query free ?.
so that our website working fast.
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!
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.