This question is related to monitoring of sql server.
1. I want to send an email alert with all open transactions on SQL Server in HTML...
I need help on this.
Basically I am looking for typical questionnaire which can be asked to customers/clients when they reach out to a...
I have a question on disks.
How much I/O can a normal disk and a SAN disk can handle?
I have heard about SAN disks should be able to...
I would love to... pl share. Thanks in advance.
Is there any tsql-query/DMV through which I can tell my workload type on database, whether mostly Reads or mostly writes happening?...
Could anybody please suggest me a way to monitor the load on my database server?
What perfmon counters should I monitor on daily basis...
Thank you for the help melvinlusk.
I want to perform performance testing on my test server?
How to capture workload from production and replay on test server?...
Can anybody share dmv queries to achieve the following ?
1. Query to capture frequently used stored procedure
2. Query to capture frequently...
Thanks for the nice explaination and I understood that we need to engage the networking guy. I was checking if there is a way through sql...
Seeking help on below .
Assuming the query execution is slow , I have collected the actual execution plan. What should I look for in...
I would like to know a way to isolate sql server bad query performance is caused by NETWORK and not the sql server.
Are there any...
Can anyone explain the below behavior for HEAP tables?
I have created a small heap table with 3 rows which can easily fit in 1 data page. Not...
Thanks for the wonderful query and suggestions. Thank you very much for the help.
Yes, it doesn't show up the memory grants which have...
Thanks for the reply. It really looks good and whatever you have said is absolutely right.
however , above query doesn't return any results in my...
Checking if anybody has a tsql script to display top 10 high MEMORY consuming queries?
Separate names with a comma.