March 11, 2011 at 1:12 am
i am a sql newbie, can somebody help me with info on how to install the tool that monitors sql activites from a client portal.:-D
March 11, 2011 at 7:39 am
What do you mean with "the" tool? Do you already have a tool in mind?
You can use SQL Server Profiler to monitor what is going on a SQL Server (http://msdn.microsoft.com/en-us/library/ms187929.aspx) or you can use perfmon to monitor resources like CPU and memory. (http://www.brentozar.com/archive/2006/12/dba-101-using-perfmon-for-sql-performance-tuning/)
A 3rd party tool to monitor SQL Server is Redgate's SQL Monitor.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 11, 2011 at 7:45 am
Or do you mean the Management Data Warehouse? This is the MSDN/BOL entry on how to deploy that.
By the way, I agree, Red Gate's SQL Monitor[/url] is a great tool.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 11, 2011 at 7:49 am
I see what you did there 😛 :hehe:
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 11, 2011 at 8:07 am
Koen Verbeeck (3/11/2011)
I see what you did there 😛 :hehe:
You set 'em up, I'll knock 'em down.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 11, 2011 at 8:13 am
Grant Fritchey (3/11/2011)
Koen Verbeeck (3/11/2011)
I see what you did there 😛 :hehe:
You set 'em up, I'll knock 'em down.
Actually, while I was writing my first reply, I was thinking:
"I'm doing Grant Fritchey's job here. Why am I not getting paid?"
😀
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 14, 2011 at 5:01 am
:w00t:thanks guys for the swift and efficient help you just gave me there, am in the process of downloading the software then give it a go, can you please advise on the proper ways i can follow to get the microsoft certification in sql server 2008 and more,
thanks in advance
😎
March 14, 2011 at 5:32 am
musa 84273 (3/14/2011)
:w00t:thanks guys for the swift and efficient help you just gave me there, am in the process of downloading the software then give it a go, can you please advise on the proper ways i can follow to get the microsoft certification in sql server 2008 and more,thanks in advance
😎
Microsoft has all the information you'll ever need for certification. Here's a good place to start.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 14, 2011 at 6:24 am
thanks so much guys, you are very specail:-D
March 14, 2011 at 6:35 am
musa 84273 (3/14/2011)
you are very specail
I hear that all the time 😀 :hehe:
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 10 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply