Archive for category T-SQL
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.
By using SQL Reports:
Right Click on SQL Server–>reports–>Standard Reports–> Memory Consumption
See the Following image.
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 firstname.lastname@example.org
Cell no. +91 9619492911(Ali)