Would like a stored procedure or process to 1) define a baseline of database(s) usage 2) monitor usage of the database(s) over time to alert on abnormal growth. I assume this would present abnormal growth or the logs (database and transaction) and the query would create a table were the values would be stored and allow for query of this table to export into a spreadsheet or graph. Feel free to advise if there may be a better way.
Bu iş için 12 freelancer ortalamada $70 teklif veriyor
Dear client. I've read your project description carefully and very interested. Let's discuss over chat and get started. Waiting for your reply. Regards.
I have 5 years experience in SQL server programming.I have created a similar alter message to generate when we see data file or log file growing abnormally and when the server is too slow
Hi sir . I can write a stored proc for you to monitor the growth of data and log file usage and We can setup alerts also. We can define our own thresholds also .We can capture auto growth events also . I can do the be Daha Fazla
Hi there I’d love to assist with this project. I’m a Microsoft SQL Server Certified MCP DBA & Developer with a passion for BI and Data. Experienced Sql Server Consultant with a demonstrated history of working in the i Daha Fazla