SQL2000 only.We use the attached script to schedule a SQL Agent job that sets up a Profile trace looking for long queries, and hourly imports them into a table. This way we can historically (but with some degree of real time) look to see what queries put a load on the system. We then allow […]
2003-08-23
1,483 reads
A stored procedure and two functions that given a path, a date and a file extension will do one of the following:-Delete all files of the supplied extension in that directory before a certain date.-Delete everything before the last full backup.I use this because disk space is tight and maintenance plans seem to delete old […]
2003-08-21
717 reads
This uses info in backup tables to display growth of datafiles (LDF and MDF) and actual datagrowth (backupsize) over a period of time. Replace parameter values with name of your database and date from when you want info displayed. Results are best viewed in grid.
2003-08-20
403 reads
2003-08-14
210 reads
This VBScript script lets you display the available disk space in each one of your administered DB servers.You have to call it with ONE argument: the filename of an archive that contains a list of known servers over which you have administration permissions. If you program VBScript, you can put alarms when any drive goes […]
2003-08-13
423 reads
This script will output an estimate for the space required for a given number of rows for a specified table; the estimated size is based on the data produced by the "sp_spaceused" stored procedure.The script is written as stand alone, though it also lends itself to creation as a stored procedure, and can be run […]
2003-08-07
4,791 reads
This script displays the size of each SQL Server database and database file plus the size of the next extension that will be added to each file. It also displays on each line the total and remaining free disk space for whichever disk each database file is stored on.The output is nothing fancy, and could […]
2003-07-30
1,320 reads
I'm trying to repost the same script submitted on 7/9/2003 which didn't get posted completely for some reason.
2003-07-27
769 reads
The following stript combines two previous articals. sp_MStablespace was being demonstrated with a cursor. To reduce the code the sp_MSforeachtable could be used.
2003-07-08
545 reads
This script will resize the data file of a passed in database name and filename by 10%. It can run in 3 modes.Resize, INFO, HELP. RESIZE is passed into parameter @Mode when we know the database name and file we wish to resize. INFO is passed in when we only know the database name and […]
2003-06-19
657 reads
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
Slow-running queries can degrade your Redshift cluster’s performance and lead to increased costs. Identifying...
By gbargsley
If you've been here before, you know this blog is usually about SQL Server,...
Layanan bantuan QLola BRI via WhatsApp 08136035412 hadir untuk memberikan pengalaman support yang cepat,...
Segera hubungi WhatsApp 08136035412 untuk bantuan QLola BRI. Dapatkan solusi cepat tanpa harus menunggu...
Segera hubungi WhatsApp 08136035412 untuk bantuan QLola BRI. Dapatkan solusi cepat tanpa harus menunggu...
In SQL Server 2025, a long I/O is recorded in the error log with message 833. How long much an I/O request be outstanding before this message is written to the log?
See possible answers