Website Seems To 'sleep' When No One Accesses It....
Jan 24, 2007
Hi,
Im currently running a website in conjuction with MSSQL Express. However at the moment the website/database seems to 'sleep' when no-one is using it, then there are huge dealays accessing the data while the database/website kicks in again. I tried to google this but truthfully i don't know what i am looking for. Does anyone have any ideas? Or whether this problem is Database or website driven? I thought there might be a control in the web.config but i haven't found a solution as yet!
Thanks
Daniel
View 1 Replies
ADVERTISEMENT
Aug 23, 2007
Hello,
Is there a way to build a program in .Net application that calls a web service, which I could activate (the program) via url?
Thank you,
Liat
View 3 Replies
View Related
Nov 15, 2007
Hello,
I am totally confused by what account I should be running my sql server database and my business layer service as.
I take it that when installing sqlserver and my service that I should be logged in as administrator.
Should I be using "Local Service", "Local System" or "Network Service" to run these processes as?
Summary of my business layer service
* Clients connect to this service on a tcp/ip port
* It accesses the file system
* it connects to the database
Thanks,
JP
View 4 Replies
View Related
Feb 11, 2008
Hello. I am called Narsiste.
I have a problem of configuration in SQL server 2005 express train. In fact, I do not know how to make the configuration to tackle the databases SQL server 2005 express train which are on a station has starting from a station B (both being in a network LAN).
But I read in the module of €œconfiguration of the surface of exposure for the services and connections - localhost€? that €œBy defect, the editions Express train, Evaluation and Developer SQL SERVER 2005 authorize only local connections.€?. As it is BY DEFECT, I said myself that it will have to be changed a parameter so that access TCP/IP can go on this version of SQL SERVER.
Here is the message which I have:
€œAn error occurred during the establishment of a connection to the waiter. At the time of connection to SQL Server 2005, this failure can be due to the fact that the default settings of SQL Server do not authorize remote connections. (Provider: Interfaces network SQL, error: 26 - Error during the localization of the waiter/the authority specified) (Microsoft SQL Server, Error: -1)€?.
If somebody encountered this problem in the past, that he wants to inform well me of the solution which he found for this last. Thank you.
View 1 Replies
View Related
Apr 1, 2004
Dear all:
Does sql server has BIF like vb sleep()?
I want to use this kind of function to balance the sql server loading,
or do you have better way to implement this task?
thanks for your kindly assistance
regards,
Stanley Huang
View 2 Replies
View Related
Apr 28, 2004
im writing a DTS package and i have am using vbscript to check if a file exists on an ftp server.
I can't figure out how to make my process sleep b/t checks on if the file exists.
in vb u can just
Declare Sub Sleep Lib "kernel32.dll" (ByVal dwMilliseconds As Long)
but i cant seem to find a counterpart in vbscript.
thanks in advance,
pete
View 8 Replies
View Related
Jul 20, 2005
HiI am trying to use the WAITFOR function to make each loop in a cursoroccur every 4 seconds until the curdb is emptythe prtocedure is as follows---------------- startcreate procedure q_additionalrabatt@additionalrabatt float,@ordernr intASdeclare @ordradnr intdeclare curdb cursor for select ordernr, ordradnr from orp whereordernr = @ordernrfor read onlyopen curdbfetch curdb into @ordernr, @ordradnrwhile @@fetch_status = 0beginupdateorpsetorp.rabatt1 = (orp.rabatt1 + @additionalrabatt)whereorp.ordernr = @ordernr andorp.ordradnr = @ordradnrfetch curdb into @ordernr, @ordradnrendclose curdbdeallocate curdb------------------- endI need to make sure, that before it fetches the next row it waits 4seconds before executing the next loop.Matt
View 1 Replies
View Related
Jan 4, 2008
Can you use 'Pause' or 'Sleep' in SQL query?
View 3 Replies
View Related
Sep 11, 2007
My reporting server seems to go to sleep after some time of non-use. This is affecting the users who create reports at the start of the day. A report that takes 1 second to generate takes 11 seconds on first hit in the morning. After the initial "wake up" call, the report server generates the reports normally without any delay. Can I keep it awake the whole time? Is there a setting somewhere?
View 13 Replies
View Related
Oct 17, 2007
I created a report using the wizard. Every thing works fine. but in one section the report returns the value of a subtotal just fine. Now I'm trying to get it to do a %(percent) using the subtotal and it keeps returning a percentage using the grand total value of what I'm adding.
i have a
group total in the group <this fine> this is want i need look down |
V
catalog %
-------------------------------------------
person total to the group<want a % based on the group>
activity total based on the total of the person activity
can any help
View 2 Replies
View Related
Jul 17, 2006
Has anyone figured out why it takes about 30-60 seconds to load a report or even get the login webpage in SSRS2005?? This seems to happen in 2 situations. One, the server has just started up and its the first request for a report or the SSRS webpage. Two, no one has requested a report or a SSRS webpage for a while (say 30min, maybe less). Its like part of SSRS has gone to sleep. Is there anyway to keep this from happening??
View 4 Replies
View Related
Jun 2, 2004
is there a way to pause a stored proc for x amount of time and then continue. I rather not go through a loop x number of times if I had to.
thanks,
DMW
View 3 Replies
View Related
Aug 22, 2007
I setup a maintenance plan in SQL and added some vbscript codes. One line is just wscript.sleep 10000. When I tried to run the job, I received error description: variable is undefined: 'wscript'
What's up with SQL?
View 1 Replies
View Related
Jun 22, 2006
Hi,
I have a script task in SSIS which uses a sleep command. sleep(600000) which waits for 10 minutes. This works fine when i execute the package through GUI. But when i execute the same with Commandline, it does not work. Is there some thing which I have not set. I have also tried the Windows API call for sleep still it behaves the same way.
Any help??
Thanks in advance
Srividya
View 3 Replies
View Related
Jul 21, 2006
The known issue about the report server going to sleep after being idle for a while is causing me a problem. I have set up a dummy sibscription to create and email a report every hour and also have set the IIS setting on the application pool the RS uses (shut down worker process after being idle for x mins, I have set this to 860!).
But the report server still goes to sleep and it can take up to 60 seconds for a report to start up.
What else can I set to reduce this problem?
View 5 Replies
View Related
May 14, 2008
So every time i run a DBCC command like DBCC SHOW_STATISTICS and DBCC INDEXFRAG, the query executes and goes on for ever. When i do a sp_who2 i notice that my DBCC SPID goes to sleep mode with high CPUTime and High DiskIO's. i also noticed that my server has no activity, no inserts, no updates and no select statements running by other users. Why cant i run a DBCC command?
You thoughts and suggestions are highly appreciated!
Thanks in advance
Lana
THE LADDERS (The Most $100k+ Jobs.)
www.TheLadders.com
View 3 Replies
View Related
Feb 14, 2008
Hi:
I have one table in which there are almost 800,000 records, and I tried to delete them by SQL stored-procedure in which executing SQL like this: "delete from tablename where date='YYYYMMDD'", once I started this procedure, I noticed SQL server will take most of CPU resources in a short period, but that's not acceptable. and there are some other useful records in this table, we can't use Drop Table.
So my question is "can we delete 1000 records and then sleep awhile, and repeat until all these records are deleted !"
Any refernece will be appreciated, thanks!
View 5 Replies
View Related
Jul 23, 2005
Hello All & Thanks in advance for your help!Background:1) tblT_Documents is the primary parent transaction table that has 10fields and about 250,000 rows2) There are 9 child tables with each having 3 fields each, their ownPK; the FK back to the parent table; and the unique data for thattable. There is a one to many relation between the parent and each ofthe 9 child rows. Each child table has between 100,000 and 300,000rows.3) There are indexes on every field of the child tables (though Idon't believe that they are helping in this situation)4) The client needs to be presented a view that has 5 of the mainfields from the parent table, along with any and all correspondingdata from the child tables.5) The client will select this view by doing some pattern-matchingsearch on one of the child records' detail (e.g. field-name LIKE%search-item% - so much for the indexes...)Problem:When I do the simple join of just the parent with one of the children,the search works *fairly* well and returns the five parent fields andthe corresponding matching child field.However, as soon as I add any one of the other child records to simplydisplay it's unique data along with the previously obtained results,the resulting query hangs.Is the overall structure of the tables not conducive to this kind ofquery? Is this a situation where de-normalization will be required toobtain the desired results? Or, more hopefully, am I just an idiotand there is some simpler solution to this problem?!Thanks again for your assistance!- Ed
View 9 Replies
View Related
Jan 10, 2007
Forgive my ignorance but I'm extremely new to SQL.
What is the easiest way to setup a web based interface to access sql data? Any help would be great.
View 3 Replies
View Related
Sep 9, 2006
I'm trying to make a searching tool in my web site that will search in one table in databaseWhat i want to do is to search by three columns and shows the result if the string found in one of this three columns, so here what i tried to and its not working okay, coz sometimes it works and other not while entering correct stringstring Search = Request.QueryString["s"].ToString(); string Sql = "SELECT * FROM Topics WHERE TopicName LIKE '% " + Search + " %' OR";Sql += " TopicIntro LIKE '% " + Search + " %' OR TopicBody LIKE '% " + Search + " %'";I also wanna know how to remove quotations and other stuff that shows error message if entered in the TextBoxThank you alot
View 6 Replies
View Related
Jun 29, 2007
HelloI am getting this err msg when trying to logon to my website on the web - on my machine there is no prob, An error occurred while established a connection to the server.When connection to Sql.S 2005, this failure may be caused by the fact thatunder the default settings sql.s doesn't allow remote connection.(provider :Sql.S Network interface, error:26- Error Location Server/Interface Specified)(the files path is like in the web host s)
View 2 Replies
View Related
Oct 20, 2005
Hi everyone. This is my
first post here. I did a quick search and didn't find what I as
looking for, so I'm hoping you all can help me.
I'm working on a project that will allow my company to upload images to
a database and have the website pull the images from the DB. We
are planning to incorporate some type of cacheing, however I'm
skeptical as to if it is really necessary. I imagine that I'm
certianly not the first to do this and I'm wondering if someone can let
me know if I truly should expect a performance hit, or if I shouldn't
really worry about it b/c this is a very common mantra.
Thanks all. I've been pretty vague and haven't explained all of
the details. I can write more, but I'm just looking for
generalizations right now.
Thanks,
HD
View 1 Replies
View Related
Mar 13, 2006
I am new to .NET and the Visual Web Developer Express and what not...I have created a website on my machine which works wonderfully...however, and I'm sure this is somewhere but I can't find it, I cannot get it to work on my host server...the Default page comes up, but when I try to sign in it says:
"An attempt to attach an auto-named database for file c:hostingwebhost4lifememberharrison0801App_Dataaspnetdb.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share."
The host support tells me to change the db name from aspnetdb to something else...I do this and when I run the site again or try to log in, I get the exact same error message...then they go on to tell me that I have to remove the LocalSqlServer in the web.config file which now looks like this:
<connectionStrings> <remove name="LocalSqlServer"/> <add name="LocalSqlServer" connectionString="Data Source=.SQLEXPRESS;Integrated Security=True;AttachDbFilename=|DataDirectory|aspnetdb.mdf;User instance=true;" providerName="System.Data.SqlClient" />
<add name="Example" connectionString="Data Source=.SQLEXPRESS;Integrated Security=True;AttachDbFilename=|DataDirectory|example.mdf;User instance=true;Initial Catalog=example;" providerName="System.Data.SqlClient" />
</connectionStrings>
Of course this isn't working either...otherwise I would off playing on my server, and not posting here. Also, when I set up all the roles, users, and what not on my machine...does this carry over to the host machine?
Desperately needing massive help here....
Not a DBA and no expert in .NET
Thank you very much in advance,
Darren
View 2 Replies
View Related
Mar 4, 2006
I'm developing a website, its completley 100% Database driven, ever piece of content is from the database, is this a bad idea?
View 4 Replies
View Related
Mar 15, 2004
I want to connect to a asp.net website....
does any1 know how to connect queries from the database to the website??
Ta
View 1 Replies
View Related
Mar 18, 2004
hi Mr.satya,
i am new to MS-SQL server 2000....
but i know well in orcle8i......
My company is going to switchover to SQLserver....
so i need startup in sqlserver.....
could u tell me the website for starters.......
that will be very helpful to me....
thanks sir
View 2 Replies
View Related
Dec 3, 2006
Hi I want to have a report on a website page that will respond to user input.
Basically a page that will displays requests when the user inputs a user_id; the user will then need to be able to drill down and select a specific request to display and print that request.
sql server 2005
visual studio 2005
win xp
View 2 Replies
View Related
Apr 13, 2007
Hi,
It's been a long time since I last experimented with SQL Server (2001) so I am not sure of new product features or developer techniques.
A client of mine is wanting to deploy an E-Commerce website and one if the core requirement is that the site must integrate with his internal MS SQL Database i.e. Orders placed online must be seamlessly entered into his internal Sales database. Ideally this would not require any re-keying or daily batch imports.
Many web hosts offer SQL hosting so how (if it is possible) could I link the hosted database to the internal database?
Any help/tips would be appreciated.
Thanks in advance
Scott.
View 1 Replies
View Related
Feb 12, 2008
Hi,
I have a web page where my users are selecting a bunch of filters to generate a report. The page then pulls the initial data from the database, applies some adjustments to the records, and then puts the data in a temporary table for that user. I want to create a report template (or a report saved on the report server) for this report. I want to use the same report for each user but be able to change the datasource for the report on the fly for the current user's temp table in my webpage before displaying the report. Is this possible?
~ Thanks
View 1 Replies
View Related
Mar 19, 2008
I would like to add a link to the RS homepage -
| Helpdesk | Home | My Subscriptions | Site Settings |
Any idea how I can get this done ?
Thanks
View 3 Replies
View Related
Feb 13, 2007
Ok, I have this up and running thanks to the help of lots of users in this forum (Thank You again)
I deployed some reports, and everything looks fine, however to add another twist to this, I would like the website to look prettier, by adding something like a welcome page,and some folders and such.
Does anyone have any ideas on how to do that ??? DO you have any material or a website, where I can get some info ??
Thanks
View 1 Replies
View Related
Dec 25, 2007
I wanted to make a login for custom content on my asp website. I installed 2005 sql, gave it a named instance(sql34). I set the connections to local and remote for tcp only in the "surface area config", and made the tcp enabled in "sql manager". All of the sql services are started. So i open up the "server management studio" and it prompts me for a connection. I sellect "database engine" because thats what i installed. I typed the server's name in the "server name" and select sql server authentication for the "authentication", and use my username and password for the login.
Then I get a message cannot connect:
the default settings sql server does not allow remote connections(provider:named pipes provider,error:40-could not open a connections to sql server)(microsoft sql server, error:2)
What is the deal with this?
Another problem was i saw the sql express does not integrate with the real sql 2005. So how do i make mywebsite's web.config(express edition) to integrate for my real sql 2005 server?
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified
View 1 Replies
View Related
Feb 6, 2008
I'm a newbie with SQL Server Reporting Services. I've played around with creating reports and I'm now ready to move on with calling reports from my C# .Net website. Does anyone know of a good tutorial to get me started? I'm specifically interested in building the SQL string on the fly using responses from the my website user and then using that string to populate the report. Thanks!
View 3 Replies
View Related
