.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
Sharon Maxwell
Post New Web Links

Purpose of Monitoring Server

Posted By:      Posted Date: September 22, 2010    Points: 0   Category :Sql Server
 

Hi Im setting up Log shipping between two SQL server (different location)

My question will be why do we need a separate monitoring server ?

From my understanding its roles is redundant whereall the belows can be done at primary/secondary server
-details of log shipping
-last backup of primary server
-last copied of secondary server
-last restored of secondary server

 




View Complete Post


More Related Resource Links

Server and Database Monitoring using SSRS

  
Hello, Everytime I search for this I keep getting reports on the SSRS server. What I want to be able to do is: Monitor for a week CPU% time vs time graph it and e-mail it to myself as a PDF. So, Monday - Friday on the 24hr clock data put onto a graph as an e-mailed PDF. I know its possible but not quite sure of how to tackle! Help!!

Purpose of "NT AUTHORITY\SYSTEM" login in SQL Server 2005

  
Hi All Does anybody know what the "NT AUTHORITY\SYSTEM" login create during a SQL Server 2005 instillation is used for? Does this login pose a security risk, and can it be removed safely?  It seems to me as if it is similar to the "Bultin\Administrator" login which we remove from our production servers? Regards Stevo

Purpose of initial "site" in SharePoint Server 2010 Express Install

  
I’m installing Search Server 2010 Express using “Farm” mode. After the SharePoint Configuration Wizard completes, and selecting  the SharePoint config wizard, one needs to create a website. What is that site intended for? Is it for the Search Center itself? (If so, then I better select the Enterprise – “Basic Search Center" template. If it is intended for a "normal" top level site, then I will create a new Search site in its own web app). TIA, Barkingdog  

Monitoring the User Activities SQl SERVER 2008 R2

  

Hi,

                Our Client Side  few people knows the sa user password. if they login through Management Studio and do some changes in data we will be the responsible for any data lose. I wannted to monitor the User activities in SQL SERVER if Users login through Management studio.If sa users connected through Application I don't want to monitor it but, when user logged in through Management Studio and do some changes in SQL server

We have to record the query fired by the user. is there any way to achieve this Please help me out.

Looking forward to hear from you

Thanks in advance

Selvakumar Rathinam

 

 

 


Selvakumar Rathinam

SQl server monitoring

  
Would like an easy method of monitoring sql servers.
There are a number clustered, stand alone, v2000, v2008, win 2003, win2008.

Would like to be able to implement this with the least impact on the server. The servers are managed and it's not quick (or cheap) to get changes authorised.

Main requirement I think is to keep records of statement/SP activity - look for long runnnig queries so that we can match it against performance issues. Would expect io and cpu activity to be a lot easier to get.

For the v2008 I am probably happy with the data collector - would be nice if it (or something like it could be implemented without a configuration change to the server though).

Need something similar for the 2000 servers also.

Anyone any suggestions?
Also need something that can be implemented quickly - getting a 3rd party tool would take too long.

Monitoring Table Size Growth in SQL Server

  
n this article I introduce a simple process that saves tables size information at points in time which latter allows for tracking down table growth over time.

The process is useful in monitoring data growth over time and lets you see what tables are growing rapidly in what databases and can also help in estimating future growth and disk space requirements. In addition it can help prevent unexpectedly running out of disk space, or if you are already in that situation then quickly find the table(s) that for some reason have grown more than excepted and are the source to the problem.

I addition, I also show a stored procedure called sp_DataFiles that returns a report of disk space usage information at the data file level.

SQL Server 2005/2008 Query Monitoring via DMVs

  

My understanding is that sys.dm_exec_query_stats is for archive aggreated query statistics so I’ve been using the query below to monitor active long running queries and it works fine for single statements – however it seems to return hugely inflated total_elapsed_time values with some procs or functions where multiple statements are run. I’m also interested if anyone know how to find query completion times from DMVs?

THANKS

Select …<some columns>
FROM sys.dm_exec_requests er
CROSS APPLY sys.dm_exec_sql_text(er.sql_handle) as st
INNER JOIN sys.dm_exec_sessions AS es
ON es.session_id = er.session_id
INNER JOIN sys.dm_exec_connections AS ec
ON ec.session_id = es.session_id
where er.total_elapsed_time / 1000.0 > @ElapsedThreshold
ORDER BY er.total_elapsed_time DESC;



call JavaScript - jQuery code from ASP.NET Server-Side

  
jQuery got so close to me lately that I can see myself adding the scripts to my project almost unconsciously. The thing is, jQuery is very useful for me, in almost all situations and it has been a do or die enhancement for all my project since I first put my hands on it.

Of course while using it, you encounter few situations which need a bit of research to solve, mostly when you are trying to combine it with some other technologies like: UpdatePanels and ASP.NET Ajax. For instance there are many situations when I would like to run some jQuery magic based on some decision that I make on the server side.

Making Ajax Callbacks to the Server Using jQuery with ASP.NET

  
In the first part of this article series I introduced jQuery's functionality and how it provides a rich client side programming model. This time around I'll expand on these concepts and show you how you can use jQuery in combination with ASP.NET using it as an AJAX backend to retrieve data. I'll also discuss how you can create ASP.NET controls and otherwise interact with jQuery content from ASP.NET pages in WebForms.


jQuery is just a JavaScript library so it will work seamlessly with ASP.NET both from page code as well as through backend driven code using the Page.ClientScript object or ScriptManager. You can use jQuery on its own as a client side and Ajax library that communicates with ASP.NET or you can use jQuery in combination with ASP.NET AJAX. The two actually complement each other quite well as jQuery provides functionality that the ASP.NET AJAX library does not and vice versa. For the most part the interaction between the two libraries is trouble free except for a few very rare edge cases.

MS SQL Server: Disconnect Users From Database - Kill User Session

  
If you ever wanted to restore your database from a SQL backup file (.bak), but there are still users connected to your database, the backup operation will fail causing the error: Exclusive access could not be obtained because the database is in use.

MS SQL Server: Search All Tables, Columns & Rows For Data or Keyword Query

  
If you need to search your entire database for specific data, this query will come in handy.

So when a client needs a custom report or some sort of custom development using Great Plains, most of the time I will have to track down the data in the system by running this query and find the table(s) it is in.

call JavaScript - jQuery code from ASP.NET Server-Side

  
jQuery got so close to me lately that I can see myself adding the scripts to my project almost unconsciously. The thing is, jQuery is very useful for me, in almost all situations and it has been a do or die enhancement for all my project since I first put my hands on it.

Of course while using it, you encounter few situations which need a bit of research to solve, mostly when you are trying to combine it with some other technologies like: UpdatePanels and ASP.NET Ajax. For instance there are many situations when I would like to run some jQuery magic based on some decision that I make on the server side

Publishing SQL Server Database using Publishing Wizard : Tips & Tricks

  
We can use SQL Server Publishing Wizard to deploy our local Database to remote hosting server/production server.This feature is available in SQL Server 2008/VWD 2008.

Below is the complete step by step guide of this process.

CLR Integration With Microsoft SQL Server

  
Transact-SQL provides as much flexibility as possible but, because it is not a real programming language, it has some shortcomings about many issues (memory management, exception handling, debugging, file processing (or streaming), object-orientation (classes), or thread management). Transact-SQL also lacks features of normal libraries (arrays, collections, serialization, expressions, or string manipulations, etc).

IP Address Blocking or Restriction in SQL Server

  
"is it possible to block connections to SQL Server based on IP address". As far as now there is no official way in SQL Server to block the connections in SQL Server based on IP address. However this can be done from the OS end, we have the following three options available, refer HERE for more.


.Firewall
.IPSec
.RRAS IP Filter

Determine whether Forms Server is installed on a server

  
Check whether the Microsoft.Office.InfoPath.Server.dll and FormServer.aspx files are installed on the server.

Connestion string create any database server

  
This links important to how to create connection string to any data base sever.
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend