SQL Server Is Frozen And No Response.

Jan 17, 2008

I have a SQL Server 2000 runing for production. Recently it is frozened occasionally.
Ath the time, no response from SQL server even I use Enterprise Manager, I can not connect to the server.

So there is no way to fixed only reboot the server.
Aftrer that, I checked the error log and go the info as:

SQL Server terminating because of system shutdown.
LogEvent: Failed to report the current event. Operating system error = 31(A device attached to the system is not functioning.).

After reboot, I checked the error log again, seems no special error except:

Attempting to initialize Distributed Transaction Coordinator.
Failed to obtain TransactionDispenserInterface: Result Code = 0x8004d01b


What's the possible reason for this issue? how to figure out and slove this problem?

View 6 Replies


ADVERTISEMENT

Problem Of Database Frozen 'inload'

Mar 14, 2000

Problem of database frozen 'inload' while doing transaction restore. Is there any way to recover this

View 1 Replies View Related

Frozen OLAP Processing. Any Ideas?

May 11, 2007

All, I am using SQL Server 2005 Developer's Edition on Windows XP Home Edition.



With the microsoft provided sample database AdventureWorksBI.msi comes with an analysis services solution called "Adventure Works DW"

Processing this solution should to produce the "Adventure Works DW" Analysis Services database.



This processing never finishes. It hangs on Processing Cube 'Customer Clusters ~MC. Specifically it hangs on Processing Partition 'Internet ~1 ~MG'. This looks like something having to do with Business Intelligence.



I am wondering if my installation "Operating System" is correct or allowable for "SQL Server 2005 Developer's Editon?



I wonder if I need to set any special security for Data Mining? As anyone had any experience with 'never finishing' Analysis Services processing.



All, opinions are welcome. I would 'like' to hear all 'possible' solutions.



Any ideas or opinions?



Thank you very much.



AIM.

Andre_Mikulec@Hotmail.com







View 2 Replies View Related

Database Backups And I / O Frozen Events

Jun 5, 2015

I am trying to find out where is the maintenance plan which is backing up SQL Dbs on its own at 12 am daily where as we didn't scheduled maintenance plans at all. We see I/o frozen and resume events every day in event l/o

Log Name:      Application
Source:        MSSQL$MSSQLSERVER2K8
Date:          5/4/2015 12:00:23 AM
Event ID:      3198
Task Category: Server
Level:         Information
Keywords:      Classic

[Code] ...

View 6 Replies View Related

Visual Studio Is Busy - Package Frozen

Oct 10, 2007

I have three very simliar packages that I edited. I added an Exec SQL Task to truncate a table. These packages are not large or complex. When I simply try to open two out of the three packages, Visual Studio hangs and I get the balloon saying it's busy. I see in the bottom left hand corner, "Validating Load Phase". This never changes. My question is how can I get into this package? I hadn't yet checked it into SourceSafe If I even attempt to single click on any step in the package, it will hang. I've also had a co-worker attempt to open the packages on his computer, and he gets the same thing, so it's definitely the SSIS package. Any help would be appreciated!

View 9 Replies View Related

SQL Server Response Time

Nov 21, 2007



When I try to connect to a SQL server instance from Enterprise Manager, I'm getting a timout connection error. I have to change the timoeout parameter from 4 (the default) to 30 in order to work.
Also I realize that some applications (like sharepoint) are having the same problem connecting to that server.

My question is:

Why is that happening?


It used to work fine, and I'm getting this issue a couple of days ago.

Appreciate your help.

View 1 Replies View Related

Don't Receive Response From Target Server

Feb 19, 2008

Hi,

I have a problem using service broker, a send the message from server SSB1(initiator) and a receive this message on server SSB2(target), but I don't receive response to SSB1...

In my server SSB2 has this messages on Profiler:
- This message could not be delivered because it is a duplicate.
- Could not forward the message because forwarding is disabled in this SQL Server instance.
- The message could not be delivered because it could not be classified. Enable broker message classification trace to see the reason for the failure.


Message from SSB1 Profiler:

- This message was dropped because it could not be dispatched on time. State: 1


And the messages not end in both servers


Tks


Fernando Bueno

View 8 Replies View Related

Slow DB Response After Server Reboots

Oct 31, 2007



I am working with a client that after every reboot of there SQL 2000 DB server, they experience slow response time for a couple of hours. The server has 12 GB RAM and a Dual 3.8 processor. It is believed that the slow response is due to as queries run after the reboot, they are re-building information in memory and after the memory is built up, it goes back to the normal performance utilizing the memory for speed. Is this an accurate assumption or is there something else to be looking at after the server is rebooted?

Thanks,
JB

View 3 Replies View Related

Connection String For SQL Server Using Challenge/Response

May 12, 2000

Hello,

I need to know if I am able to use OLE DB connection strings without the username and password for Challenge/Response logins.

I have a web site that uses SSL and Challenge/Response to authenticate users, but my connection to the database is by embedding a generic username and password in the connection string.

I would like to leave that off and have the connection to the database use the challenge/response authentication when they first logged into the web site. This way I can control their permissions in SQL server.

I appreciate any help

Kevin

View 1 Replies View Related

Slow Query Response From A Linked Server

Oct 17, 2006

Hello,

I have 2 servers (say MAINSRV e SECSRV) running SQL2000 Standard SP3 on Windows 2000 Advanced within a NT (!) domain and each server is linked to the other.

My problem is that if I run a query returning few dozens of rows like:

SELECT * FROM MAINSRV.DbName.dbo.TblName TBLA
WHERE Fieldx = 'anyval'

from a client connected to the SECSRV server, it takes something like 35 minutes to complete, while the same query completes in no time when run on clients connected to MAINSRV.

Even the simplest SELECT Count(*) FROM... takes more than one minute from SECSRV while completing in a fraction of second from MAINSRV.

I tried to change the linked server security options (SQL/Windows), but the remote query remains slow.

There are no locks active on the table, both the servers have almost no load (CPU less than 10%, when tested) and the query returns just a few KBytes, so communication overhead will not be the problem.

Any suggestions will be very appreciated, thank you!!!

View 2 Replies View Related

SQL 2005 Client Response With SQL 2000 Server

Oct 10, 2007



I have recently installed SQL 2005 client tools with SQL Server Management Studio and accessing databases on a SQL 2000 server. The response I am getting is extremely slow. Should I go back to SQL 2000 client or are there methods by which I can improve the performance.

Thanks
Sam

View 1 Replies View Related

SQL Server 2000: The Agent Is Suspect. No Response Within 10 Minutes

Apr 20, 2007

Hi,



I have two servers, one production server and one backup server which have transactional replication with a pull subscription.



When I configure replication, it works fine during our test weekends testing production load. After tests, replication looks fine for a random number of days. Then, all of a sudden, an error message is displayed on one of the agents: "The agent is suspect, no response within 10 minutes." This has happened a number o times. If I remove replication and configures it again, it always works. Sometimes it works by just updating one of the tables and the error message disappears. The last time (today) that did not work. Updating the database did not replicate and the error message remained.



Has anyone experienced this same problem and has a god solution. One thing that is common is that the error message appears after long times of inactivity on the servers, or perhaps after a restart but that I am not sure about.



Question 1: How can I prevent this error message?



Question 2: Are there any special things to think about when I need to restart the servers and replication is configured, e.g. after installing updates from Windows Update.



I would be very grateful for any answers regarding this.



Best,
/M

View 1 Replies View Related

SQL Express Browser Response To 2000 SQL Server Service

Dec 14, 2007



Please assist, the issue with SQL 2005 Browser and SQL 2000 Server Service is understood.

Our problem is with networked 2000 instances and SQL Express. The SQL 2000 machines (Standard & MSDE) do not have SQL 2005 or Express installed only 2000. When a SQL Express computer is put on the network with the SQL Browser service running almost all SQL 2000 machines lose sight of the other SQL 2000 instances. The second the
SQL Browser is turned off on the SQL Express box the SQL 2000 machines can see each others instances.
It appears that the response from the SQL Express SQL Browser causes the SQL 2000 machine to stop listening for responses. Once in a while one of the SQL 2000 instances will show up with the SQL Browser active on the network and it is my belief that it is because that response made it in before the SQL browser response. Please help as this does not appear to be a recognized issue. I'm assuming there aren't many sites running as many named instances on individual machines like we do.

Please note this appears to be a problem with SQL Express Browser not SQL 2005 Standard's which runs without problems on our network.

THANK YOU!

View 1 Replies View Related

Outlook Runs Very Slow Frequently Non-response, SQL Server Using Up To 1GB Memory - VISTA && Office 2007

May 14, 2008

When I launch Outlook, it takes forever for the program to finally open. With any inbound email, it stops processing whatever is underway at the time....and frequently there is a 2-3 second lag between keyboard input and what appears on the screen. SQLserver is usually consuming upwards of 1-gb of memory....help. Mike

View 1 Replies View Related

Read Text File From SQL Server, Read Its Content, And Load It In RichTextBox (Related Component: Context.Response.BinaryWrite(), And StreamReader)

Nov 26, 2007

OBJECTIVE: I would like to read a text file from SQL Server 2000, read the text file content, and load its conntents in a RichTextBoxTHINGS I'VE DONE AND HAVE WORKING:1) I've successfully load a text file (ex: textFile.txt) in sql server database table column (with datatype Image) 2) I've also able to load the file using a Handler as below: using System;using System.Web;using System.Data.SqlClient;public class HandlerImage : IHttpHandler {string connectionString;public void ProcessRequest (HttpContext context) {connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["NWS_ScheduleSQL2000"].ConnectionString;int ImageID = Convert.ToInt32(context.Request.QueryString["id"]);SqlConnection myConnection = new SqlConnection(connectionString);string Command = "SELECT [Image], Image_Type FROM Images WHERE Image_Id=@Image_Id";SqlCommand cmd = new SqlCommand(Command, myConnection);cmd.Parameters.Add("@Image_Id", System.Data.SqlDbType.Int).Value = ImageID;SqlDataReader dr;myConnection.Open(); cmd.Prepare(); dr = cmd.ExecuteReader();if (dr.Read()){ //WRITE IMAGE TO THE BROWSERcontext.Response.ContentType = dr["Image_Type"].ToString();context.Response.BinaryWrite((byte[])dr["Image"]);}myConnection.Close();}public bool IsReusable {get {return false;}}}'>'>
<a href='<%# "HandlerDocument.ashx?id=" + Eval("Doc_ID") %>'>File
</a>- Click on this link, I'll be able to download or view the file WHAT I WANT TO DO, BUT HAVE PROBLEM:- I would like to be able to read CONTENT of this file and load it in a string as belowStreamReader SR = new StreamReader()SR = File.Open("File.txt");String contentText = SR.Readline();txtBox.text = contentText;BUT THIS ONLY WORK FOR files in the server.I would like to be able to read FILE CONTENTS from SQL Server.PLEASE HELP. I really appreciate it.

View 1 Replies View Related

Response.WriteFile Help

Jan 12, 2007

Every so
often I am seeing this error in the Event Viewer on Windows 2003
Server. It  related to a file that pulls documents from a SQL server db using Response.BinaryWrite. When it pulls a file of about 2MB it creates a warning in the EventViewer. I was told to look at using Response.WriteFile to pull the file instead. I found this page: http://support.microsoft.com/kb/306654  which talks about it but doesnt give an explination on how to integrate with grabbing the content. Does anyone know how to pull db content and use WriteFile and put the file into the Response. Similar to this: Response.Buffer = TrueResponse.Clear()Response.ContentType = contentTypeResponse.AddHeader("content-disposition", "attachment; filename=" + fileName)Response.BinaryWrite(content)Response.Flush()Response.End()

View 11 Replies View Related

Try,Catch And Response

Jul 2, 2007

Hi,
Here is the code:Try
If DS.Tables(0).Rows.Count = 0 ThenResponse.Write("Cannot delete an unexist row!")
Response.End()
End If
DS.Tables(0).Rows(0).Delete()
Catch BUG as Exception
Response.Write(Bug.Message)
End Try
I removed all the connection stuff..
What I don't understand is why if ds.table(0).rows.count is zero I still get Bug.Message? I did Response.End ...
Thank you.

View 11 Replies View Related

Response Time

Mar 6, 2008

Regarding SSRS, what is considered a good response time? We have some reports running 2 minutes and the users think that is too long. Is there a guideline as to what a user should reasonably expect and if so, what is that guideline?

View 2 Replies View Related

Wait For A Response?

Jun 11, 2007

Hi. We are migrating a mainframe datacom database to SQL Server. One of our client-server applications already uses SQL Server. This application uses a middleware product to query and update the datacom database being migrated. We are considering using Service Broker to replace the middleware.

In many cases the client does not need a response provided the message is queued and will eventually get delivered. However, in some cases the client would like to wait for the message to be processed before proceeding. Is there an easy way to both submit and optionally wait for a response - with data - in a single stored procedure? If client does not want to continue to wait, is there a way to use a procedure to check for the returned message later?

We have not used Service Broker before and are doing for a "sanity" check before proceeding. We do not want to tightly couple the two databases at this time.

View 4 Replies View Related

SP Response Time

Nov 12, 2007

In my SQLSERVER2005 EXPRESS

I Detached all databases and attached with new set of databases from SQL2005 Developer edition from different server.


Now My important SP response time increased from 00:00:00(before detaching old set of databases) to 00:00:08

How to improve query response time for SQLSERVER2005 EXPRESS

earlier it worked fine

Thanks

View 4 Replies View Related

SQL Query Response Time

Mar 30, 2001

Why is the response time to run a query faster when the output is displayed in grid format as compared to text format?

View 1 Replies View Related

RESPONSE TIME IS TOO SLOW

Aug 21, 1998

Hi
I have Problem, My response time is too Low. Is Any one Know how to improve my response time. My DATABASE SIZE IS 11 GB. I didn’t change any configuration parameter after installing SQL Server. Right my server Having default configuration parameters. Whether I have to change any parameters or not. My queries will generate lot of temporary tables.

Thanks

JK

View 2 Replies View Related

Slow Client Response

Aug 10, 1998

At my location we are running Great Plains on SQL server with the Great Plains client on the front end communicating over IP Sockets. Occasionally the client will stop responding for up to 15 minutes. This occurs to all clients at the same time. While this is happening I have ran performance monitor on the SQL server using the SQL counters and everything looks fine. Performance on the server and the network does not degrade. Only the Great Plains client is affected. From this I feel this is not a network problem. I would like some suggestions on what could possible cause this type of problem. I am really just looking for a starting point on where the problem may be originating from. Any suggestions will be greatly appreciated.

thanks.

View 1 Replies View Related

Slow Response From A 32 Bit To 64 Bit Connection.

Feb 29, 2008

Here is the configuration we have at our site:
64 bit virtual server - Clustered 64-bit SQL Server 2005 Standard SP2 listening on port 1433.

32 bit virtual server - 32-bit application that connects to above SQL Server 2005 via standard OLEDB driver installed with windows (String utilized: Provider=SQLOLEDB.1;Persist Security Info=False;Initial Catalog=applicationdb;Data Source=ServerInstanceName).

We are experiencing a slow reponse of 45 sec to more than a minute on a simple select statement on a table having 5000 rows.

The same select statement on the Server locally in Studio returns results back in 2 seconds or less. But from Stuido on any other desktop (remote) it takes 45 secs or more. Same slow response is seen by the application which is using OLEDB.

I've looked into some of the Server parameters but didn't find any clues.

Any help is greatly appreciated.

View 2 Replies View Related

Response Message Failed

Aug 10, 2007

Hello everyone,

I have three merge publications that use web synchronization. The first publication works with no problem. When I try and sync the second publication, I get the following error messages:

"The operation timed out"
"The Processing of the response message failed".

So, I upped the query timeout from 300 seconds to 900 seconds. Now I get the following error messages:

"The connection with the server was terminated abnormally"
"The Processing of the response message failed".


I am using the Synchronize applet (found in the Accessories menu) to test my publications.

The third publication also works with no problem, so I do not see why the second one fails.

The only difference between the three is the following:
The first replicates a small handful of UDF's
The second replicates all tables (and has some filtering applied)
The third replicates all stored procs, views, and remaining UDF's.

Any ideas?

Thanks...

View 1 Replies View Related

Increasing Response Time

May 26, 2008

Hello,

I am currently migrating a DB from Oracle to SQL Server (Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86))

I've used ssma to do the migration, and I'm reviewing the prodedures to check them. I have find a performance problem in one of them, which worked perfectly under Oracle, and I have tried lots of things with no luck, so I guess I need some help

I insert a row in a table, and the time it takes for this is fine, but seconds later I need to read the row, and this Select lasts 1-2 ms more every time. This process is repeated lots of times.

Every insert-select takes 200 ms when it receives the first data (including some other operations that are not increasing the response time), and 200 insertions later it takes about 500 ms, which is really too much, considering it keeps increasing.

The table has 25+ columns, and some of them contain varchar of 3000+ characters.

I make the select using 4 columns in the where part. One of them is a numeric, and the rest are varchar (no one is the primary key).

I've got a clustered index for the primary key, and two more non-clustered indexes. One of them refers to the columns I use in the Select, and the parameters are Fill Factor: 90, and Recompute Statistics Automatically.

I hope I explained properly...

Any ideas?

View 8 Replies View Related

Slow Response From SQL 2005

Sep 28, 2007

hi,

I ran into a situation that if I don't use sql server for a while, in MS SQL Server Management Studio, when I run some query again, it takes a long time to respond. I looked into it with Activity Monitor, seems like the query was waiting for something, in the process view tab, it shows that:
WaitType: LATCH_EX
Resource: LOG_MANAGER(112F88C8)
What is the latch-ex? What should I check next to find out the problem?

Thanks.

View 4 Replies View Related

Query With Multiple ID To Check And Response...

Jan 27, 2007

Hi there, I tried to make it different as usual but i´m stacked into this problem:Supose TABLE DetailsID_DET    ID_CAR    DETAILS1              3             1,2,3,4,5,62              4             2,43              5             5,6,7,8andTABLE  Details_ItemsID_DI       DETAIL_NAME1             Stereo HiFi CD2             Alarm3             AirConditioning4             LeatherSeats5             Pro Wires6             Aluminium WheelsThe problem appears when i need to bring CAR DETAILS (NAME) from TABLE DETAIL_ITEMS.Mi guess i that I should make something like:SELECT * FROM DETAILS_NAME WHERE id_di = ((  Array(i) FROM  Details  )) one by one...I really dont know how to face it.First I thought in bringing ALL details_Items (datafieldtext = id_di and datavaluetext=Details_names) into a dataview.And then "somohow?" filter this dataview according with the Array previuosly splited by me with a For each function.Then I thought "Perhaps" there is a simpliest way to do that using SQL views, o advanced SQL QUERYS.and Finally I thought that creating a VIEW in for both TABLES would be great.The point is that, neither 1,2,3 options, honestly , I dont know how to face them.Thanks in advance, apologise my "rude" English grammar.LUCAS ( From Argentina )
 
 
 

View 2 Replies View Related

Response.Redirect && Request.QueryString

Apr 12, 2007

I have 2 pages. ( i want to pass information from a text box to the "certificate.aspx" database query)
page 1 certsearch.aspx
this is my script i have a label, commnad button, & textbox
If txtSearchCert.Text = "" Then
lblMsg.Text = "Please enter a certificate #"
Else
Response.Redirect("certificate.aspx" & txtSearchCert.Text)
End If
 
page 2 certificate.aspx
i am not sure what goes here.this is what i am trying
Request.QueryString = (txtSearchCert.text)
This is my database query on certificate.aspx page
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:imacsConn %>"
SelectCommand="SELECT * FROM [SummaryBlue] WHERE REPORTNUMBER = ?"></asp:SqlDataSource>

View 3 Replies View Related

Return XML To Response.write From SQL XML Type

Jul 23, 2007

Hi,
I am trying to retrive some XML from my SQL server 2005 database. The XML is in a table called "myxml" and it is being stored a native XML. The Field type is "XML". The VB code returns nothing when I select SELECT xml. How ever if i SELECT NAME it displays the correct name from the name field. how do I return the XML to be viewed as XML throught the response.write?
 Thanks!
Here is my Table definition:




Column Name
Data Type
Allow Nulls

Id
Int
 

xml
xml
Yes

NAME
Nvarchar(50)
yes
My XML that is stored in the XML field:
<ROOT>
<CHAPTER>
<TITLE>This is a test</TITLE>
</CHAPTER>
</ROOT> 
Here is my VB code:
   Dim myconnection As SqlConnection
Dim mycommand As SqlCommand
myconnection = New SqlConnection()
myconnection.ConnectionString = _
ConfigurationManager.ConnectionStrings("myxmlConnectionString2").ConnectionString

Dim strSQL As String = "SELECT [xml] FROM myxml WHERE id = 76"

' create SQL command instance
mycommand = New SqlCommand(strSQL, myconnection)

Try
' open database connection
myconnection.Open()
'execute T-SQL command
Dim dr = mycommand.ExecuteReader()
While dr.read()
Response.Write("<p>" & dr(0).ToString() & "</p>")
End While
Response.Write("GOT IT")

Catch ex As Exception
Response.Write(ex.Message)
Response.Write(strSQL)
Response.End()


End Try
' Close connection
myconnection.Close()
 
 

View 1 Replies View Related

Slow Query Response - Is It The Hosting.

Mar 16, 2006

Hi all,
I have a website www.searchcontracts.com which has a search feature on the front page. The problem is that whenever a search is submitted (without and filters) it processes extremely slow (if at all, sometime throws 'general network' errors). If working properly it will return about 500+ records. As far as i know if there should be no issues returning a recordset of this size. I have the site hosted in a shared environment and it uses a SQL2000 db. If you filter the search resutls, it's more reponsive (still fairly slow).
If you believe that the hosting server i'm using should be upgraded, what would be the best solution? Keep in mind that i want to be able to return way more than 500+ records in one go.
Thanks
Jakehttp://www.searchcontracts.comhttp://www.custommethod.comhttp://www.boozetour.com
 
 

View 3 Replies View Related

Slow Response Time After Converting DB From SQL 6.5 To 7.0

Feb 10, 2000

We did an in place convertion of our data base from MS SQL Server 6.5 to 7.0.
Our application is much slower now on SQL 7.0. Any idea why?
The following is a sample SQL statement that runs quickly on SQL 6.5 and takes a long time on SQL 7.0 I also attached the query plans from SQL 6.5 and 7.0.




SELECT Person_Name.PerNam_Person_Name_PK ,
Person_Name.PerNam_Row_Status ,
Person_Name.PerNam_Last_Name_Sndx ,
Person_Name.PerNam_Last_Name ,
Person_Name.PerNam_Name_Suffix ,
Person_Name.PerNam_First_Name ,
Person_Name.PerNam_Name_Prefix ,
Person_Name.PerNam_Middle_Name ,
Person_Name.PerNam_Event_Person_FK ,
Event.Evn_Event_Nbr ,
Event.Evn_Event_Type ,
Event_Person.EvnPer_Last_Name ,
Event_Person.EvnPer_First_Name ,
Event_Person.EvnPer_Middle_Name ,
Event_Person.EvnPer_Name_Prefix ,
Event_Person.EvnPer_Name_Suffix
FROM Person_Name , Event , Event_Person
WHERE (Person_Name.PerNam_Agency_ID = "CL")
AND ( Person_Name.PerNam_Event_Person_FK = Event_Person.EvnPer_Event_Person_PK )
and ( Event_Person.EvnPer_Event_FK = Event.Evn_Event_PK )
and (Person_Name.PerNam_Person_Name_PK = 0 or ( Person_Name.PerNam_Event_Person_FK = 581541) )
and ( Person_Name.PerNam_Row_Status <> "D" )




Query plan in SQL 6.5

SQL Server Execution Times:
cpu time = 0 ms. elapsed time = 31250 ms.
STEP 1
The type of query is INSERT
The update mode is direct
Worktable created for REFORMATTING
FROM TABLE
Person_Name
Nested iteration
Index : PK_Person_Name
FROM TABLE
Person_Name
Nested iteration
Index : PerNam_Event_Person_FK
FROM TABLE
Person_Name
Nested iteration
Using Dynamic Index
FROM TABLE
Event_Person
Nested iteration
Index : PK_Event_Person
TO TABLE
Worktable 1
STEP 2
The type of query is SELECT
FROM TABLE
Worktable 1
Nested iteration
Table Scan
FROM TABLE
Event
Nested iteration
Index : PK_Event
SQL Server Parse and Compile Time:
cpu time = 0 ms.
Table: Person_Name scan count 2, logical reads: 6, physical reads: 5, read ahead reads: 0
Table: Event scan count 0, logical reads: 0, physical reads: 0, read ahead reads: 0
Table: Event_Person scan count 0, logical reads: 0, physical reads: 0, read ahead reads: 0
Table: Worktable scan count 0, logical reads: 0, physical reads: 0, read ahead reads: 0
Table: Worktable scan count 1, logical reads: 1, physical reads: 0, read ahead reads: 0

SQL Server Execution Times:
cpu time = 0 ms. elapsed time = 62 ms.



Query plan on SQL 7.0

SQL Server parse and compile time:
CPU time = 431 ms, elapsed time = 535 ms.
.................
Table 'Event'. Scan count 1, logical reads 3, physical reads 3, read-ahead reads 0.
Table 'Event_Person'. Scan count 1, logical reads 6, physical reads 5, read-ahead reads 0.
Table 'Person_Name'. Scan count 1, logical reads 4588, physical reads 2, read-ahead reads 4092.

SQL Server Execution Times:
CPU time = 7921 ms, elapsed time = 13519 ms.

SQL Server Execution Times:
CPU time = 0 ms, elapsed time = 13781 ms.

View 2 Replies View Related

XML Request/response Over Http In Ssis

Sep 6, 2007

Hi,

I've a xml file which I need to send over http to another server. The other server processes xml file and sends back xml response over http.

How can this be achieved in SSIS.

Thanks

Manish

View 5 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved