SQL Server Dba Simulation
I'm looking into creating a SQL Server database and then creating some T-SQL scripts which simulate stress/ a load on the database. Which I can then investigate using windows performance monitor, to highlight the causes of the load, and how to fix it. The aim of this is to train an ability to investigate database performance problems and how to fix them.
I'm new to database administration (SQL server DBA) but I can't seem to find many resources/information on performance and creating fake loads to test performance.
Any help would be appreciated.