Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MS SQL Server






SuperbHosting.net & Arvixe.com have generously sponsored dedicated servers and web hosting to ensure a reliable and scalable dedicated hosting solution for BigResource.com.







RESPONSE TIME IS TOO SLOW


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 Complete Forum Thread with Replies
Sponsored Links:

Related Messages:
Slow Response Time After Converting DB From SQL 6.5 To 7.0
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 Replies !   View Related
SSIS Response Time Very Slow.
Hi

i had a problem with the SSIS  response time  - its very slow.

When I try to open the solution and than click to open the Pakage it's take at least 6-10 minutes until it's open.

 

Please advice what can be the reason

10x

 

 

View Replies !   View Related
Newbie: Slow Response Time Querying Systemjobhistory
Hi,

I have a problem with querying systemjobhistory data. Response time is slow and it is vary from time to time, sometime it takes few seconds and sometime it takes more than 2 minutes. I understand that there is quite a number of jobs in DB server and which might result in slow response time.

Is it possible to shorten the response time? like using index? My application is always look like hang when the query take very long time to run.  

Any help is greatly appreciated. Thank you.


Regards,
maxChin 

View Replies !   View Related
Slow Client Response
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 Replies !   View Related
Slow Response From A 32 Bit To 64 Bit Connection.
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 Replies !   View Related
Slow Response From SQL 2005
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 Replies !   View Related
Slow Query Response - Is It The Hosting.
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 Replies !   View Related
Slow DB Response After Server Reboots
 

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 Replies !   View Related
SQL Batch - Slow Response - Remote DB Query
Hello.I have a slow response with a system that I am setting up. The OS isWin 2000 Server with SQL Server 2000. My first execution of the SQLprocedure is slow (about 40 seconds), while the second execution isfaster (approx. 3 seconds and what I expect).Using query analyser I can leave the window up and come back ( aftersay 10 minutes ) and my next response is will be slow (and fasterstraight after this).The query itself is the "TOP 10" rows from a table of a remote DB (MSDE2000 - NT station).This is similar to;---------------------DECLARE @SelectRowsFromRemoteDB NVARCHAR(400)SET @SelectRowsFromRemoteDB = "SELCT a.* FROM OPENROWSET('SQLOLEDB', 'Remote', ....) a"EXEC sp_executesql @SelectRowsFromRemoteDB---------------------The CPU usage goes high (with Task Manager), but oddly the task withmost usage is the "Idle Process".Please help with an answeror a good starting point to known where the resources are being used.Regards JC.....

View Replies !   View Related
Slow Query Response From A Linked Server
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 Replies !   View Related
Response Time
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 Replies !   View Related
SP Response Time
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 Replies !   View Related
Outlook Runs Very Slow Frequently Non-response, SQL Server Using Up To 1GB Memory - VISTA &&amp; Office 2007
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 Replies !   View Related
Response Time....URGENT!!
What are the things that we need to monitor and what we need to use mostly to moniter web applicaion using SQL server databases.Some internal users are complaining of response time to connect to SQL server being more'What is it?Where to look for what?Is it something to do with memeory?Server is having dynamic memory management option set.We are using DTS to transfer data every 30 minutes.Size of the database is 24MB,using SQL server 7.0 with SP2.Please help.

View Replies !   View Related
SQL Query Response Time
Why is the response time to run a query faster when the output is displayed in grid format as compared to text format?

View Replies !   View Related
Increasing Response Time
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 Replies !   View Related
SQL Server Response Time
 

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 Replies !   View Related
Stored Query Response Time
When I execute the SQL query below in Query Analyzer it takes one second to return 84 rows. When I execute the exact same query through a stored procedure it takes over one minute to return the same 84 rows. Can someone please explain why this happens and what, if anything, I can do to fix it?

select * from loans where short_name like 'byrne%'

View Replies !   View Related
Query Response Time Check
Is there a global variable or something of the sort that would tell me how long it took to execute a query??

I need to monitor my DB response times and we have a query that runs in under 2 seconds. So we want to run this query every couple of minutes and if it takes more than 12 sec to run, we want to send an email to our DB staff...

I know that I could take a time stamp before and after then subtract but I wanted to know if there was an easier way to do it..

Thanks.

View Replies !   View Related
Urgent Advice: MDX Query Response Time
I am using SQL 2000 Enterprise with analysis services running on windows server 2003.

Please can you advise me how you measure the MDX Query performance (response time) i.e Time in seconds.

I have tried using System / performance monitor with no luck.I have looked at the MDX Sample application again without any successs in meauring the time it takes to measure an MDX query.

Thanks,

Anders

View Replies !   View Related
Problems With A Specific User For Response Time From SP
I have a user that is used for a three tier system that has exec permissions on a ll the Stored Procedures.

I'm experiencing a problem in Production where the response time has diminished alot. a std SP running in dev takes sub second response time

when run on PROD it takes 13+secs and this proc is called alot through MTS

we tested the SP with the dedicated user with exec privileges and runs very slowly I ran update stats on the DB nothing changed, ran DBCC DBREINDEX after still no change.

Used a user in the sysadmin group same SP responds under a second.

test the same proc under the dev system dedicated user and sysadmin user respond sub second.

This problem really has got me stumped.

Here is the code of the proc in question it is used for User validation

Got indexes on both tables involved, did checkalloc, checkcatalog found
nothing abnormal....

/*
Description: This procedure returns employee information for the specified login
Arguments:
@Logon char(6)Employee Logon
*/
CREATE PROCEDURE sp_Employee_View(@Logon varchar(10)) AS

declare @Branch char(4)
declare @ChildBranches varchar(8000)
declare @BranchList varchar(8000)

SELECT @Branch = sBranch
FROM Employee
WHERE sLogon = @Logon and Employee.sStsCode = '1'

EXEC sp_GetRelatedBranches @Branch, @ChildBranches OUTPUT

IF @ChildBranches is null or @ChildBranches = ''
begin
SET @BranchList = '''' + @Branch + ''''
end
ELSE
begin
SET @BranchList = '''' + @Branch + ''',' + @ChildBranches
end

SELECT Employee.*, Branch.*, @BranchList as sBranchList
From Employee
LEFT JOIN Branch ON Employee.sBranch = Branch.sBranch
WHERE sLogon = @Logon and Employee.sStsCode = '1'


/****************/
/* ErrorHandler */
/****************/
declare @LastError as int
select @LastError=@@ERROR
if @LastError<>0
begin
declare @objName varchar(255)
declare @userName varchar(15)
declare @mess varchar(255)
select @objName=OBJECT_NAME(@@procid)
select @userName=user_name()
select @mess=description from master..sysmessages where error=@LastError
set @mess= cast(@LastError as varchar(5)) +'-'+ cast(@mess as varchar(240))
execute spSys_logError @@servername, @objName,@mess , @userName
end
GO

/*
Description: This procedure returns the list of branches related to the specified branch
Arguments:
@BranchNumber char(4)Branch Number
@BranchList varchar(8000) OUTPUTParameter in which the branches list will be returned
*/
CREATE PROCEDURE sp_GetRelatedBranches(@BranchNum char(4), @BranchList varchar(8000) OUTPUT, @RecursiveCall AS boolean = 0) AS

DECLARE @RelBranchNum char(4)
DECLARE @FirstLevelBranches varchar(8000)
DECLARE @OtherLevelsBranches varchar(8000)
DECLARE @Temp varchar(8000)
DECLARE @TempBranch char(4)
DECLARE @CommaPos int
DECLARE @GetBranchesByArea boolean
DECLARE @BranchGroup char(4)

SET @BranchList = ''
SET @FirstLevelBranches = ''
SET @OtherLevelsBranches = ''
SET @Temp = ''


IF @RecursiveCall = 1
begin
SET @GetBranchesByArea = 0
end
ELSE
begin
SELECT @BranchGroup = sBranchGroup
FROM Branch
WHERE sBranch = @BranchNum

IF @BranchGroup IS NOT NULL
begin
SET @GetBranchesByArea = 1
end
ELSE
begin
SET @GetBranchesByArea = 0
end
end

IF @GetBranchesByArea = 1
begin
DECLARE curBranch CURSOR FOR
SELECT sBranch FROM Branch WHERE sBranchGroup = @BranchGroup
FOR READ ONLY

OPEN curBranch

/* Get First Level Branches */
FETCH NEXT FROM curBranch INTO @RelBranchNum
WHILE @@FETCH_STATUS = 0
begin
IF @RelBranchNum <> @BranchNum
begin
IF @BranchList = ''
begin
SET @BranchList = '''' + @RelBranchNum + ''''
end
ELSE
begin
SET @BranchList = @BranchList + ',''' + @RelBranchNum + ''''
end
end
FETCH NEXT FROM curBranch INTO @RelBranchNum
end

CLOSE curBranch
DEALLOCATE curBranch
end
ELSE
begin
DECLARE curBranch CURSOR FOR
SELECT sBranch FROM Branch WHERE sRelBranch = @BranchNum
FOR READ ONLY

OPEN curBranch

/* Get First Level Branches */
FETCH NEXT FROM curBranch INTO @RelBranchNum
WHILE @@FETCH_STATUS = 0
BEGIN
IF @FirstLevelBranches = ''
SET @FirstLevelBranches = '''' + @RelBranchNum + ''''
ELSE
SET @FirstLevelBranches = @FirstLevelBranches + ',''' + @RelBranchNum + ''''

FETCH NEXT FROM curBranch INTO @RelBranchNum
END

CLOSE curBranch
DEALLOCATE curBranch


/* Get Other Levels Branches by recursive calls to procedure */
IF @FirstLevelBranches <> ''
BEGIN
SET @CommaPos = charindex(',', @FirstLevelBranches)
IF @CommaPos = 0
/* Only one related branch*/
BEGIN
SET @TempBranch = substring(@FirstLevelBranches, 2, len(@FirstLevelBranches) - 2)
EXEC sp_GetRelatedBranches @TempBranch, @OtherLevelsBranches OUTPUT, 1
END
ELSE
BEGIN
/* First Branch */
SET @TempBranch = substring(@FirstLevelBranches, 2, @CommaPos-2)
EXEC sp_GetRelatedBranches @TempBranch, @Temp OUTPUT, 1

IF ltrim(@Temp) <> ''
BEGIN
IF @OtherLevelsBranches = ''
SET @OtherLevelsBranches = @Temp
ELSE
SET @OtherLevelsBranches = @OtherLevelsBranches + ',' + @Temp
END

/* Next Branches */
WHILE @CommaPos <>0
BEGIN
IF charindex(',', @FirstLevelBranches, @CommaPos + 1) > 0
SET @TempBranch = substring(@FirstLevelBranches, @CommaPos+2, charindex(',', @FirstLevelBranches, @CommaPos + 1) - @CommaPos - 1)
ELSE
SET @TempBranch = substring(@FirstLevelBranches, @CommaPos+2, len(@FirstLevelBranches) - @CommaPos - 2)

EXEC sp_GetRelatedBranches @TempBranch, @Temp OUTPUT, 1

IF ltrim(@Temp) <> ''
BEGIN
IF @OtherLevelsBranches = ''
SET @OtherLevelsBranches = @Temp
ELSE
SET @OtherLevelsBranches = @OtherLevelsBranches + ',' + @Temp
END

SET @CommaPos = charindex(',', @FirstLevelBranches, @CommaPos + 1)
END
END

IF @OtherLevelsBranches <> ''
SET @BranchList = @FirstLevelBranches + ',' + @OtherLevelsBranches
ELSE
SET @BranchList = @FirstLevelBranches
END
end


/****************/
/* ErrorHandler */
/****************/
declare @LastError as int
select @LastError=@@ERROR
if @LastError<>0
begin
declare @objName varchar(255)
declare @userName varchar(15)
declare @mess varchar(255)
select @objName=OBJECT_NAME(@@procid)
select @userName=user_name()
select @mess=description from master..sysmessages where error=@LastError
set @mess= cast(@LastError as varchar(5)) +'-'+ cast(@mess as varchar(240))
execute spSys_logError @@servername, @objName,@mess , @userName
end
GO

any help is really appreciated

Stephen Mandeville
Database Administrator
Systems & Technology
Business Development Bank of Canada
Phone: (514) 283-8708
Fax: (514) 496-8058
e-mail:: stephen.mandeville@bdc.ca
e-mail home:: alkor@videotron.ca

View Replies !   View Related
Is It SQLServer 2005 Express Cause Slowness In Response Time?
Hi,Did any body experiences slowness for response time in SQLServer 2005 Express? Is it because it is free so that's why it is slow?This related to my post at :http://forums.asp.net/thread/1246577.aspx
Thanks in Advances,Environment : Windows 2003 Web ServerDatabase : SQLServer Express 2005Others Database : Postgres 8.NET Framework 2.0
 

View Replies !   View Related
SQL Server Very Slow For 10 Minutes At A Time
We have an application that has about 100 users at a time. Roughly once a day, we experience a complete
slowdown on the server. All users notice it. The network seems fine because I can ping the server. Also,
I can attach to drives on the server quite fast so I don`t think it`s server resources. When I manage to
get in and do an sp_who, certain processes are blocking others. Talking to the users who were blocking,
they were not doing anything out of the ordinary - one was even doing just a select. The error log is full
of 17824 and 1608 errors. Is there some configuration setting that I should change? This is getting serious!

Thank you.

View Replies !   View Related
Temptable Access Time SLOW
I have a stored procedure which creates 3 temporary tables. Every table is about ten rows and 25 columns. The inserts in the tables goes fast (< 30 ms). The selects from them is also that fast. BUT the first select takes about 3200 ms one each of the temptables. (I first do insert, then select from them.) So the SP executes at about 13 seconds instead of 3.

Any suggestions, anyone, please?

View Replies !   View Related
Database Is Slow To Access After Being Idle For Some Time
I've noticed that after the database have been idle for some time, it takes up to 10 seconds to get it started when something needs to access it. In the event viewer it says that the database <name> have been started.

Obviously, there is some idle timeout setting.

I saw an option in the database properties that is called "Auto Close" which is set to true. I assume this is what i'm looking for. Can someone confirm that? (it could take some time to test myself...)

But what i'm actually wondering is:

1. Is it possible to adjust how long it would wait before timing out?
2. What advantages does closing the database bring? Does it free up (a noticeable amount of) ressources? Or is it only that it's unlocking the files, so that it's possible to copy the database source files?

View Replies !   View Related
Slow Moving Dimension And History Time Stamp
The following question might sound a bit stupid but I'm not a database expert so hopefully nobody minds me asking it.

Here's what I did:

1. I created an SSIS package that is supposed to import new data into my data warehouse as it becomes available.

2. Since I need to maintain some of the history I use the Slow Moving Dimensions part (set the history flag on input fields) but run into an error condition while running the package. The message basically says that I'm about to create a duplicate record which is not allowed.



Original Table1:

PK1 field1
PK2 field2
PK3 field3
field4
field5

-----------

Now I enhanced it like this:

Extended Table1:

PK1 field1
PK2 field2
PK3 field3
field4
field5

CreateDate (new)
NewDate (new)
ActiveFlag (new)
_____________________

Now on some records the package is supposed to archive history by populating the (new) fields. In order to keep the record unique (primary key constraint) thought, do I need to make the (new) fields primary keys as well?

So I guess I'm struggling with a more basic concept;)

I would appreciate if somebody could shed some light on this.

Thanks in advance.
Dirk

View Replies !   View Related
Slow Respons Time From Reporting Service Over Sharepoint
I am running SQL 2005 reporting services on a windows 2003 machine with SharePoint over SSL

My reporting services web directories are virtual directories under the SharePoint website. 

I am having a problem with loading https://sharepoint.mysite.com/Reports/Pages/Folder.aspx

When you first open IE and bring up the page it takes about 30 seconds to load.  Once you have connected via any machine, all other machines can connect at normal speed 1-2 seconds.  All testing is being done on our LAN so there is no bandwidth issues when opening the pages. 

My guess is that something is going into a sleep mode, but I am not sure where that would be set.

Thanks for any suggestions

Robert

View Replies !   View Related
SSRS Website Slow When Accessing It The First Time After Inactivity
The SSRS website is slow when accessing it the first time after a period of inactivity (30 min. or longer).  What could be causing this and how can I make it fast all the time.

View Replies !   View Related
Web Application That Deals With Slow/time Consuming Database Processes
Hello All, 
I’m looking for a solution to timeouts that occur when I’m executing a stored procedure from my web application. Most of the SPs will run from 3 to 15 minutes, and, unfortunately, modifying/optimizing them isn’t an option at the moment. I tried setting the CommandTimeout to 0 with no luck. Unless, I didn’t use it properly. Here’s my code:  1
2 try
3 {
4 string dbConn = ConfigurationManager.ConnectionStrings["ConStringNTMTLDEV"].ToString();
5 OleDbConnection connection = new OleDbConnection(dbConn);
6
7 lbl_SearchResult.Text = dbConn;
8
9 //OleDbDataAdapter adapter = new OleDbDataAdapter();
10 OleDbCommand cmd = new OleDbCommand("SP_CallHistoryLookUp", connection);
11 cmd.CommandType = CommandType.StoredProcedure;
12
13 cmd.Parameters.Add(new OleDbParameter("@phoneNumber", "1234567890"));
14 cmd.Parameters.Add(new OleDbParameter("@email", "123@123.com"));
15 cmd.Parameters.Add(new OleDbParameter("@WebUser", "123"));
16 connection.Open();
17 cmd.CommandTimeout = 0;
18 cmd.ExecuteNonQuery();
19 cmd.Dispose();
20 connection.Close();
21 }catch(OleDbException ex)
22 {
23 lbl_SearchResult.Text += "&lt;br/> Something went wrong </br>";
24 lbl_SearchResult.Text += ex.Message.ToString();
25 }
26
27
28
  Is it possible to launch a stored procedure and close the connection without waiting for a result?Would the stored procedure still run on the SQL server? I’m using MSSQL 7. Would you have any examples that would solve this problem? Thank you for your help. 
R.
 

View Replies !   View Related
Access Time Too Slow After Converting A Field Fron SmallInt To Int
:confused: Hi everybody, I'm in a middle of something weird to me, I hope not to You :). I have a Table in a Database that use to hold around a millon of registers. and It had been working very well. My problem actually began when I changed a field Data type, from SmallInt to Int. After that, accessing that table is too slow, I've already reindexed the table, and even already return the field Data type to SmallInt, and reindexed again. The problem continues.

I saw by the Query Analizer that the problem is mainly when I try to update a register in the Table where idDetail = @idDetail.

It last 3 seconds... when, before the issue it was inmediatly. In task manager the SQLSRV. exe only uses 25% of processor, but memoy use is really increased. (This update has to be done several times per minute)

I tested with a new empty table. I inserted few records... and obviously it worked as fast as it used to do. But with the table with real data It doesn't

Any suggestion it'll help me.

Thnx in Advance

MiguelVV

View Replies !   View Related
Why My Query Is Slow When I Execute Full Text Search Service For Firts Time
first sorry my english,

when i execute a query for the first time whith full text service from visual studio, show me the error 'server not responding' and when i execute this query for second time works perfectly.

View Replies !   View Related
Slow Excecution Time Using &&"TOP X&&" Statement
Hi, I have a query which returns normally in less than a couple of seconds. When coupled with a "TOP" statement however, the execution time changes in a way I can't explain.

 

When using "TOP 1000", the query returns in its normal time. Any top value greater than 10 seems to function normally. However, as soon as we hit this "magic number" the query begins taking 30+ seconds to return.

 

As far as we can see, there is nothing odd about this query or the data that it is searching, and this problem has us stumped! Can anyone explain why top is producing these results, and is there any optomisation changes that anyone can suggest to give us faster queries in these cases?

 

Many thanks, Andy J.

 
 
 
 

View Replies !   View Related
How To Convert UTC Time (retrieved From SQL) To Local Time In Reporting Services Based On Time Zone
 

Hi all,
 
I have created a report in SSRS 2005 which is being viewed by users from different Time Zones.
 
I have a dataset which has a field of type datetime (UTC). Now I would like to display this Date according to the User Time Zone.
 
For example if the date is August 07, 2007 10:00 AM UTC,
 
then I would like to display it as August 07, 2007 03:30 PM IST if the user Time Zone is IST.

 
Similarly for other Time Zones it should display the time accordingly.
 
Is this possible in SSRS 2005?
 
Any pointers will be usefull...
 
Thanks in advance
sudheer racha.

View Replies !   View Related
Try,Catch And Response
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 Replies !   View Related
Response.WriteFile Help
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 Replies !   View Related
Wait For A Response?
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 Replies !   View Related
1 Client Has Poor Response
When I use other clients or PCanywhere to the server, I get a select * from sysobjects time of about 10 seconds. However, one client (which happens to be mine) is very slow, same query takes over 4 minutes to complete. All ODBC settings are the same, and since it is a laptop I have disconnected and reconnected to other ports which work fine. I have tried TCP/IP and named pipes. This client spins the hard drive the whole time it is waiting for results, almost like it has a virtual memory problem (its a 650 mhz 256 mb ram dell laptop). I have also re-installed and reconfigured TCP/IP and MDAC and all ODBC. Other network performance tests (ie file transfer) are ok.

Any ideas?

View Replies !   View Related
Response Message Failed
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 Replies !   View Related
Replication - Unrecognized Response
Hi,

I am performing merge replication with web synchronization, suddenly some of the clients which perform pull subscription are failing with the error:

"The server returned an invalid or unrecognized response"

Is this related to this problem by any chance:
<http://support.microsoft.com/kb/838893/>

SYMPTOMS


When you try to use Microsoft Internet Explorer 6 Service Pack 1 (SP1) to view a Web page, you may receive an error message that is similar to the following error message:
The server returned an invalid or unrecognized response.
CAUSE

This problem may occur if the following conditions are true:



€˘
You have installed the cumulative security update for Internet Explorer MS04-004.

€˘
You try to access a Web page that is secured by basic authentication.
We are using IE SP1 and Basic Authentication. How do I solve this problem

View Replies !   View Related
SQL Server Is Frozen And No Response.
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 Replies !   View Related
Return XML To Response.write From SQL XML Type
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 Replies !   View Related
Response.Redirect && Request.QueryString
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 Replies !   View Related
Query With Multiple ID To Check And Response...
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 Replies !   View Related
SQLServerException: The TDS Prelogin Response Is Incomplete.
I'm trying to connect to a SQL-Server from Java using code that worked OK beforeanother place:connectionUrl ="jdbc:sqlserver://Xpserver:1433;databaseName=orthodata;user=sa";Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");con = DriverManager.getConnection(connectionUrl);But now I get:com.microsoft.sqlserver.jdbc.SQLServerException:The TDS prelogin response is incomplete. The target server must be SQL Server2000 or later.Any ideas?- - -The source:http://rhj.mine.nu/s/TestConnection.htmlLog:http://rhj.mine.nu/s/logg_2008_01_14.txtI doubt that the SQL Server is older than 2000.--Rune H. Johansen, +4722253241, +4795939001, http://rhj.info/

View Replies !   View Related
Sql Resuest/response Adapter In Biztalk
Hi,

I am trying to test a stored procedure in my sql adapter with Biztalk 2004 that inserts records and then returns a xml page showing what records were inserted. I first tried with just inserting the records and that worked fine, but when I add the select statement and changed the sql adapter to a request/response I got the error:

Streaming not supported over multiple column result

Though when I test it in Query Analyser it works fine?

All I really want is some response to say that the procedure was successful, if it isn't possible the way I have tried can someone then suggest how I can do this? I would appreciate any help!!!

Thanks, Shazz

here is my stored procedure:


CREATE PROCEDURE sp_UpdateTestPricelist

(
--UpdateArticle table
@SupplierArticleGUID uniqueidentifier='{00000000-0000-0000-0000-000000000000}',
@SupplierGUID uniqueidentifier='{00000000-0000-0000-0000-000000000000}',
@SupplierArticleDescription nvarchar(150)='sugar',
@SupplierArticleNumber nvarchar(50)='4711',
@EAN nvarchar(50)='',
@VatKeyValue int=16,
--UpdateArticlePrice table
@SupplierArticlePriceGUID uniqueidentifier='{00000000-0000-0000-0000-000000000000}',
--@SupplierArticleGUID uniqueidentifier,
@ValidFrom datetime='',
@ValidTo datetime='',
@UnitOfMeasurement nvarchar(50)='kg',
@LotType uniqueidentifier='{00000000-0000-0000-0000-000000000000}',
@LotSize decimal(6,2)=1,
@GrossWeight decimal(6,2)=0.0,
@NetWeight decimal(6,2)=0.0,
@UnitPrimeCost decimal(6,2)=0.0,
@LotPrimeCost decimal(6,2)=0.0,
@Currency nvarchar(50)='EUR'
)
AS

DECLARE @ImportDate int

SET @ImportDate = year(getdate()) * 10000 + month(getdate()) * 100 + day(getdate())


DELETE FROM UpdateArticlePrice WHERE SupplierArticleGUID IN (SELECT SupplierArticleGUID FROM UpdateArticle WHERE ImportDate <> @ImportDate AND SupplierGUID = @SupplierGUID)
DELETE FROM UpdateArticle WHERE ImportDate <> @ImportDate AND SupplierGUID = @SupplierGUID

BEGIN
SET @SupplierArticleGUID = newid()
SET @SupplierArticlePriceGUID = newid()
INSERT INTO UpdateArticle
(
SupplierArticleGUID,
SupplierGUID,
SupplierArticleDescription,
SupplierArticleNumber,
EAN,
VatKeyValue,
ImportDate
)
VALUES
(
@SupplierArticleGUID,
@SupplierGUID,
@SupplierArticleDescription,
@SupplierArticleNumber,
@EAN,
@VatKeyValue,
@ImportDate
)

insert into UpdateArticlePrice
(
SupplierArticlePriceGUID,
SupplierArticleGUID,
ValidFrom,
ValidTo,
UnitOfMeasurement,
LotType,
LotSize,
GrossWeight,
NetWeight,
UnitPrimeCost,
LotPrimeCost,
Currency
)
VALUES
(
@SupplierArticlePriceGUID,
@SupplierArticleGUID,
@ValidFrom,
@ValidTo,
@UnitOfMeasurement,
@LotType,
@LotSize,
@GrossWeight,
@NetWeight,
@UnitPrimeCost,
@LotPrimeCost,
@Currency
)
END

SELECT * FROM UpdateArticle UA, UpdateArticlePrice UAP
WHERE UA.SupplierArticleGUID=UAP.SupplierArticleGUID
AND UA.SupplierGUID=@SupplierGUID
--for xml auto, xmldata
GO

View Replies !   View Related
XML Request/response Over Http In Ssis
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 Replies !   View Related

Copyright © 2005-08 www.BigResource.com, All rights reserved