Monitor network resources used by single database

SQL Server Database Engine

Index ‹ SQL Server

- Previous
  - 1
    - When you create a cube, does it have constant connection to the DB after the cube is created If you read the link, then you'd understand storage modes. At which point, you'd be able to answer your own question, instead of having someone type if out for you, since MSDN does a fine job of that. Tag: Monitor network resources used by single database
  - 2
    - Reporting Services Configuring Default Error Messages freezinice wrote: I am just wanting to add to the error message or modify the error message. Do I need to load something into VS I am not creating a new report. I just want to modify the original message that SQL Server Reporting Services gives you during any type of error via IE. I'm not sure that you can do that. Basically what I did was create my own report (just a basic SQL report) that has an error message on it. I used it in my Visual Studio web application by handling the OnError event of the report viewer and simply displaying the error report. However, if you haven't developed a front end for your reports then you wouldn't be able to use this approach. Tag: Monitor network resources used by single database
  - 3
    - need to changes the default port address of apache server can any one guide me how to change the default port address of apache which is 80 to any other port number. coz the default port number is taken by iis also. Tag: Monitor network resources used by single database
  - 4
    - selecting top 20 and the rest Thanks Kieth and Arnie! Both your responses were very helpful. I was really hoping for another way to get the result since the select statement that pulls the ID and amounts is so complex and resource-heavy that I didnt want to run it more than once. In that way, Arnie's solution is better and I can get the results without bringing down my server. Thanks again, Anand Tag: Monitor network resources used by single database
  - 5
    - how can I substract a SUM from a SUM? Here is the query: SELECT v.visit_id, v.visit_guid, v.created_date, v.direct_or_insurance, v.visit_file_no , vi.total_visit_amount, vi.discount_amount, vi.total_visit_amount - vi_discount_amount AS total_minus_discount FROM visits AS v (SELECT visit_id , SUM(item_price) as total_visit_amount , SUM(CASE item_code WHEN 'DISCOUNT' THEN item_price END) as discount_amount visit_items.item_code != 'DISCOUNT' FROM visit_items GROUP BY visit_id ) AS vi ON vi.visit_id = v.visit_id WHERE v.visit_is_open = 'Y' AND v.visit_file_no = @file_no Couple of points: 1. Including visit_file_no in GROUP BY clause is unnecessary since you are retrieving rows for a specific file_no anyway 2. Based on the relationship, you don't need GROUP BY on that many columns. Often you want to perform the grouping before you do the join to get better performance especially in case of 1-N relationship 3. I simplified the query and added table aliases to make the code more readable / easy to maintain. Tag: Monitor network resources used by single database
  - 6
    - Problem in Installing SQL Server 2000 Personal Madhu, Thanks for pointing out my mistake.......apologize for my ignorance Tag: Monitor network resources used by single database
  - 7
    - Deployment problem Help Hello all experts, I have tried to deploy my cube using an XML Script in dev box, modify connecting string by changing server name, run in QA box, and process cube, but always failed. Error massage: боProcess failed. Trace information is still being transferred. If you do not want to wait for all of the information to arrive press Stop.бп Any one had experience for this error Thanks in advance. Tag: Monitor network resources used by single database
  - 8
    - Reporting Services printer problem I have a windows NT service, which prints to a laser printer programmatically using MSRS 2K. It works fine with a HP printer however when I try printing to a Lexmark Printer it does not always print. Somebody help. Microsoft please release a latest patch for MSRS 2K, its been so long since we had one. Tag: Monitor network resources used by single database
  - 9
    - Month/Year comparison against a date I don't think that is exactly 'right'. (I did make the assumption that the OP wanted ONLY JULY 2007 dates.) Follow this code: Code Snippet DECLARE @StartDate datetime, @EndDate datetime SELECT @StartDate = '06/7/2007', @EndDate = '7/15/2007' -- Arnie's Variation -- Starting at midnight, 7/1/2007, Ending at midnight, 8/1/2007 SELECT 'Arnie', dateadd( month, datediff( month, 0, @StartDate ) + 1, 0 ), dateadd( month, datediff( month, 0, @EndDate ) + 1, 0 ) -- Mandip's Variation -- Starting at midnight, 5/31/2007, ending at midnight, 8/1/2007 SELECT 'Mandip', dateadd( month, datediff( month, 0, @StartDate ) , -1 ), dateadd( month, datediff( month, 0, @EndDate ) + 1,0 ) -- OP Requested -- the sp needs to select all records that come -- after 6/30/2006 and on or before 7/31/2007 ----- ------------------------- ------------------------ Arnie 2007-07-01 00:00:00.000 2007-08-01 00:00:00.000 ------ ------------------------ ------------------------ Mandip 2007-05-31 00:00:00.000 2007-08-01 00:00:00.000 Tag: Monitor network resources used by single database
  - 10
    - VB6 RDO error Did you try naming the owner of the procedure as a prefix of the procedure It is recommended to always qualify the procedure / objects with their whole name including the schema / owner name. Jens K. Suessmeyer --- http://www.sqlserver2005.de --- Tag: Monitor network resources used by single database
  - 11
    - Transaction Question When I run the following in Query Analyzer: SET QUOTED_IDENTIFIER OFF -- allows double quotes (") used as wrapper for dynamic sql. DECLARE @E int BEGIN TRAN T1 PRINT 'Start...' EXEC ( " begin tran T2| raiserror( ' inside proc', 16, 11) PRINT STR(@@ERROR) rollback tran T2 PRINT STR(@@ERROR) return " ) SET @E = @@ERROR IF @E <> 0 BEGIN PRINT 'Error ' + LTRIM ( STR ( @E )) + ' out of here...' ROLLBACK TRAN T1 RETURN END PRINT 'Done.' COMMIT TRAN T1 I get the following output and error: Start... Msg 50000, Level 16, State 11, Line 3 inside proc 50000 Msg 6401, Level 16, State 1, Line 5 Cannot roll back T2. No transaction or savepoint of that name was found. 6401 Msg 266, Level 16, State 2, Line 7 Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRANSACTION statement is missing. Previous count = 1, current count = 2. Error 266 out of here... Anyone have an idea why I would get the 6401 and 266 error JD Waleska, GA MSBassSingerNO-SPAM@alltel.NO-SPAMnet (just remove the string NO-SPAM) Tag: Monitor network resources used by single database
  - 12
    - Unable to install SQL Server CE Server Tool on SQL Server 2000 SP 4 Hi, I have installed " SQL Server 2000 SP 4" to SQL server and it is running fine. But when i install the " SQL Server CE version 2.0 Update for use with IIS and SQL Server 2000 SP4 ", i get below error: "SQL Server CE Tool is compatible only with SQL Server 2000 Service pack 1 and higher. When you install SQL Server CE Server Tools on a computer running both IIS and SQL Server 2000 , ensure the installer for SQL Server CE Server Tools corresponds To the version of SQL Server 2000." I have go thougth few articles in the forum, try to open the sqlce20sql2ksp4.exe file and then run only the MSI, but still fail. By the way, i found that the sqlce20sql2ksp4.exe does not include any MSI, it is a direct executable file. Appreciate if anyone tell me the solution. Thanks in advance. Best regards, Plane. Tag: Monitor network resources used by single database
  - 13
    - Integrating SSRS with report viewer In your web project Add reporting web service reference Use ListChildren mothed to get all reports Use GetReportLink mothed to get report link Pass link to reportviewer. You can find the details about these two mothed from MSDN Tag: Monitor network resources used by single database
  - 14
    - successful implementation of dataware house and data mining hi all i want an article on a company or organization that has successfully implemented dataware house and data mining, and by its help they have been able to increase their business or sale etc etc help will really be appreciated Tag: Monitor network resources used by single database
  - 15
    - Aggregation wizard Thanks for the response, I did a refresh and then a new count and this did not update the counts. I tried deleting all of the counts in the wizard and the recount gave the correct counts but when procedding in the wizard, the % imporovement was zero when it reached the max partition size. With the prvious record counts, I had a 21% improvement with a smaller partition. Any thoughts Steve Tag: Monitor network resources used by single database
  - 16
    - USING SSIS for scheduled import StartMenu > ControlPainel > AdministrativeTools > Services Helped regards! Tag: Monitor network resources used by single database
- Next
  - 1
    - Drop database on a different SQL Server. As far as I know, in this case, you have to recreate the sproc on target server. Tag: Monitor network resources used by single database
  - 2
    - replicating UDT's to subscribers I am not sure if this will solve your problem but you can try re-initializing your subscription before regenerating a new snapshot. -Raymond Tag: Monitor network resources used by single database
  - 3
    - XQUERY / XPATH versus nodes containing ":"-character Hi, all. I'm having problems using XPATH / XQUERY versus input containing ":" in the node names. Example: Code Snippet <MyData:Output xmlns:MyData=" www.myprovider .com"> <MyData:Provider> <MyData:Property MyData:Name="FirstName">Joe</MyData:Property> </MyData:Provider> </MyData:Output> T-SQL (breaks): Code Snippet SELECT XMLContents.query('/MyData:Output/MyData:Provider') FROM dbo.Some_Table __________________________________________________________ XQuery [dbo.Some_Table.XMLContents.query()]: The name "MyData" does not denote a namespace. However, if I remove all the "MyData:" references from code and data, it works fine. I don't have an option of getting the incoming data changed; is there a way to escape the character to get this code to work Tag: Monitor network resources used by single database
  - 4
    - SQL Server vs. XML Configurations You aren't by chance defining a SQL Server connection (in the package configuration) for the very connection that you need to get to the package configuration table, are you Tag: Monitor network resources used by single database
  - 5
    - converting to numeric (6,3) Hey guys, I am trying to achive the following: Truncate the values 1680.390000000000000000 to numeric (6,3) All works ok until i hit a value over 1000, (as above) The code i was using is: cos1 = 1680.390000000000000000000 CONVERT (NUMERIC(6 , 3), ROUND(COS1, 3)) I have tried a few others, but nothing seems to work.. I get the following error. "Arithmatic Overflow" Has anyone got any suggestions Thanks guys, Scotty Tag: Monitor network resources used by single database
  - 6
    - Datasource Views and Teradata I'm trying to to use SSAS 05 w/ our Teradata warehouse (VERSION 05.01.02.70 RELEASE V2R.05.01.02.40) and I'm having a problem creating datasource views. My issue is that the wizard returns every view and table in the warehouse (tens of thousands) which takes over 10 minutes . I can't seem to limit it to only the database I'm intersted in using. I've tried using the restrict schema option but then no objects are returned. Any ideas on how to do this Can you create the datasource views without the wizard Thanks. Tag: Monitor network resources used by single database
  - 7
    - Understanding code created by SSIS import/export Wizard Why can you not change these things in SSIS Designer (i.e. BIDS) -Jamie Tag: Monitor network resources used by single database
  - 8
    - SQL Server 2005 Service Pack 2 - RTM - WHEN??? Hi, Does anybody know how many CTPs will be provided before the RTM will be delivered Thanks Tag: Monitor network resources used by single database
  - 9
    - Parameterized Queries Just getting started using SSce and having a few problems What I want to do is something like this... Dim Code As Integer Dim Description As String = txtDescription.Text.Trim Dim conn As SqlCeConnection = ConnectToLocalDatabase() Dim ssql As New System.Text.StringBuilder ssql.AppendLine( "INSERT INTO T_Titles (Description)" ) ssql.AppendLine( "VALUES(@Description)" ) ssql.AppendLine( "SELECT @Code = @@IDENTITY" ) Dim cmd As New SqlCeCommand(ssql.ToString, conn) Dim sqlCode As New SqlCeParameter( "@Code" , 0) sqlCode.Direction = ParameterDirection.InputOutput cmd.Parameters.Add(sqlCode) cmd.Parameters.Add( New SqlCeParameter( "@Description" , Description)) cmd.ExecuteNonQuery() Code = CInt (sqlCode.Value) ********************************************************************** The above code doesnt work. Firstly I am not sure if I can execute the two statements in one go. Secondly, I am not sure if output parameters are supported. I have been working with SQL Server since 6.5 but have always used sprocs and am feeling a little lost here without them. Any help getting started would be greatly appreciated. Thanks Tag: Monitor network resources used by single database
  - 10
    - Users and Roles script In 2005, is there a way to automate this I'd like to be able to do this automatically periodically: 1) Script out the development users and their roles in my development database 2) Backup the production database and restore the it to the development database 3) Re-synch the existing users (sp_change_users_login), drop any obsolete users (sp_dropuser), and add any development users with roles back on Does anyone have a script that can help me achieve this Tag: Monitor network resources used by single database
  - 11
    - how to extract this text? I have options_field contains a lot of data.. here are examples: DTбдNBбдNMбдANI=80088080 39139662 ANI=80088080 36637576 бдDNIS=80088080бдDTбдNBбдNMбдUNIT ANI=80088080 39188390 бдANI=8008808017403125бдDNIS=80088080бдDTбдNBбдNMбдUNIT ANI=80088080 39653135 бдALIASбдDNIS=80088080бдDTбдNBбдNMбдUNIT ALIASбдANI=80088080 39169467 бдANI=8008808017326875бдUNITбдNMбдNBбдDTбдDNIS=80088080 DTбдNBбдNMбдDNIS=80088080бдANI=80088080 36331200 бдANI=80088080 39318646 I want to extract every 39 and 36 mobile numbers in the ANI. All numbers are 8digits as highlighted ad some records will have more than mobile number while some won't have any mobile number listed. so the result should be 39139662 36637576 39188390 39653135 39169467 36331200 - 39318646 Tag: Monitor network resources used by single database
  - 12
    - Differences in varchar size usage, declaring the maximum available of 8000 characters SQL Server does not really allocate space based on the datatype definition in your table. It allocates enough space to hold the data (so if you have 10 chars, it only allocates space for 10 chars). After the data is in memory, one of the checks we do is check the length of the data against the defined length. If the size of the data is bigger, we raise an error. Internally, SQL Server uses several algorithms to avoid too many memory allocations (sometimes it allocates more than needed if it finds out that a lot of string concatenation is being done). The defined size of a variable does not really play a big role here. Are you using SQL Server 2000 or SQL Server 2005 If you use SQL Server 2005, you can use the varchar(max) datatype, which will hold data up to 2GB, and you never really have to worry about the size. SQL Server will do the right thing for you. Only when your data gets bigger than 8K, you might get a small perf hit when using varchar(max) as it won't fit on a single page anymore, but if you have a lot of data that is smaller than 8K, you might as well use varchar(max) as internally in the engine varchar(N) and varchar(max) are treated very simular as long as the data is less than 8K. Hope this helps, Marcel van der Holst [MSFT] Tag: Monitor network resources used by single database
  - 13
    - Daylight Saving Time DST 2007 Problems so, instead of a 5 hour difference between the two you should see a 4 hour difference Tag: Monitor network resources used by single database
  - 14
    - end conversation : security context could not be retrieved HI I was reading the other thread about no security header and check the time in the enqueue time, which was ahead of the server time the last enqueue_time on the target was 2007-04-13 22:27:16 but when I did a select getdate() I get 2007-04-13 20:24:03 how can the enqueue time be in the future thanks Paul Tag: Monitor network resources used by single database
  - 15
    - Unicode causes Dimension build failure? The SQL Server is using Collation SQL_Latin1_General_CP1_CI_AS The Analysis Server is set to Latin1_General, with Accent-Sensitive enabled. These appear to be the same, are these considered the same Tag: Monitor network resources used by single database
  - 16
    - Change member properties order in excel 2007 pivot table Hi everyone, i am trying to change the member properties order in a excel 2007 pivot table but it wont work... I've found how i should do it according to Microsoft Office web site ( http://office.microsoft.com/en-us/excel/HA101777521033.aspx , see : Display member properties as data in a PivotTable report ) but even if i follow the instruction by the letter it is not working... I've searched a lot but i can't find anything on this... Anybody's having the same issues or know a way around it I'm using SSAS 2005 SP2 and Excel 2007 Thank you very much! Tag: Monitor network resources used by single database

mohd sufian

Hi,

Is there any methord to monitor network utilization per database on single instance of SQLServer2005 or SQLServer2000.

Please help

Regards

Mohd Sufian

Top

Re: Monitor network resources used by single database

lkh

The tools are Profiler, accessable from the Tools menu in SSMS or Start/Programs/SQL Server/Performance Tools or perfmon accessable from Start/Programs/Administrative Tools/Performance.

The tool to use depends on the meaning of "network utilization". Profiler will allow you to run a trace you can use to aggregate reads, writes and duration by database. Perfmon has many counters that can be used by database.

See SQL Server 2005 Books Online topics:

SQL Server, Databases Object

http://msdn2.microsoft.com/en-US/library/ms189883.aspx

Monitoring Resource Usage (System Monitor)

http://msdn2.microsoft.com/en-us/library/ms191246.aspx

Top