Archive for category T-SQL

Finding out how much memory SQL Server is utilizing?

Many time for a new DBA  hard to find how much My Server utilising memory? Here is explained a number of ways to find the memory utilized by SQL server.

By Using Performance monitor:

 Go to Start–>Run and type perfmon . You will find the following screen where you can see the total memory used(the pages/sec) by your box.

By Using DMV:
You can Query to sys.dm_os_memory_clerks DMV to find out Memory utilization by SQL server. To see how see the following link.

http://www.sqlservercentral.com/Forums/Topic1188221-391-1.aspx

By using SQL Reports:

Right Click on SQL Server–>reports–>Standard Reports–> Memory Consumption

See the Following image.

Advertisements

Leave a comment

DBA certification on SQL server in Mumbai:

DBA certification on SQL server in Mumbai:

 

I like to teach SQL server 2008(DBA) Certification Exam 70-432, after passing this single exam you will tagged as MCTS (Microsoft Certified Technology Specialist). Which is I have passed with an 83%. I offer private tuition for interested students/ professionals with a competitive fee in industry.

            The training institutions ask a sound fee but most of them unable to deliver the knowledge and expertise for passing the exam and also to work with technology.

 

I am having approx 10 years of professional experience in IT field, see about me and my certifications

 

If any one interested to be an SQL server DBA, at there time and place (any where in Mumbai Only), just contact me on ali_tailor@yahoo.com

Cell no. +91 9619492911(Ali)

Leave a comment

Hi All

This is a try to help SQL DBA/Dev. as much as pasble, Just I want to help all new bie in Microsoft SQL Server technology. You can leave any question related to SQL server, It will be answerd ASAP.

Thaks

Mahmood Ali

2 Comments