2 Sec In Management Studios And 90 Sec From Vb.net
Nov 1, 2007
Hello,
I am hoping some of you can direct me to areas I should look into.
First off let me say that everything was fine and worked great up until 3 weeks ago.
Then all of a sudden we began to experience timeouts on a particular query.
The vb.net 2002 code has not changed and is pretty basic stuff to connect to the server and execute the query. The only change I have made to it since then is to add a commandtimeout parameter so it would actually run.
There does not seem to be a specific pattern either to when it runs slow and when it does not.
I can be the only one in the server in the morning (the only one in the office for that matter) and one day the application will execute the query and return data in under 9 seconds and the next day it will be a minute and a half.
I can test it during peak network times and the same thing...one day fine the next day performance is slow.
Also, if I run the query straight from the management studio it will run in 2-9 seconds and from .net it takes 20-90 seconds.
Are there server admin jobs I could run to see if tables are deadlocked, if the network is to busy..anything?
I have VB2008 express edition and SQL server 2005. When i try to create a new local datasource in my project, the datasource seems to be created just fine however an error message comes up. If i try to create the datasource by selecting it on the 'add new item' menu, an error message says
"The data provider required to connect to the local data file could not be found. The file will be added to the project but the typed Dataset associated with the project will not be created."
If I try to create the datasource by selecting 'add new datasource' from the datasources pane, i can create the connection to a new or existing database but when i click next to proceed to the page defining the dataset, an error message says
"An error occured while converting this connection: Data provided identified by guid ' 7c602b5b-accb-4acd-9dc0-ca66388c1533 ' could not be loaded"
I am running Visual Studios 2005 enterprise edition and I am creating a mobile application to keep track of some receipts. The problem I'm currently having is that even though I can connect to the MS Access Database with Server Explorer that I'll be aquiring data from; Everytime I attempt to use the Data Configuration Wizard to add a new data source that namely the database I get this error message:
The new connection uses a data provider that is not supported. (end of message)
There is no username or password necessary to access this database and it is an Access 2003 database.
I have recently installed the SQL Server Management Studio Express but I do not find Management Tools in order to create scheduled backups and shrinking of the databases. I was under the impression that this should be included in the Management Studio. I use the SQL 2005 Express for smaller customers who run the SQL on a desktop unit. I need a way to backup the data to a server machine for backup purposes. I have uninstalled and reinstalled to no avail.
dont know y, but i have prob. installing MS Management studio....After a hard drive failure I was forced to reinstall everything... :( The problem is that after installing vs2005 proffesional edition I installed the sql server 2005 trial edition and everything was fine during the installation.When I looked for the Management studio it wasnt there for me :( I uninstalled and reinstalled trying the full installation but results was the same, no Management studio!!!After uninstalling the SQL server trial edition I installed the Management studio express and it works. except that from some reason I cannot browse my XP user folder which has no password protection.. :( Any idea for installing the SQL trial edition including the Management studio ???Why can't I browse my XP folder with Management studio express ???Where can I download Management studio (non express version)?? regards
I have looked everywhere I can think of for the answer to this and am completely confused. My IT dept created an SQL database for me on a server. My plan is to create web pages in asp.net using Visual Web Dev Express released this week. I have connected to the database but I can't figure out how I am supposed to create my tables in the database. What simple/obvious thing am I missing here? I keep trying to download SQL Server Express in hopes that I can use that to manage my database but it keeps telling me that it won't install because I have previous Beta versions left on my machine. I can't find those either so am out of luck. I am new to this so perhaps I am asking all the wrong questions.Does anyone know what I can do to find a useful database management tool that will allow me to add/create the tables?Thanks for any help!
Apologies if this has been covered elsewhere, but can anyone give me a insight how you manage servers in Enterprise Manager on the MMC effectively?
It seems that there is no refresh facility on the SPID view functions, and it appears impossible to monitor what is actually going on on a real-time basis. SPIDs can appear and disappear, but without refreshing the whole server and drilling down to the right area each time there appears to be no update on the activity on that server.
I have been able to zoom no-existant SPIDs - and SPIDs I have set up running massive queries persisantly show 'sleeping' unless the whole server is refreshed.
I was less than impressed with the 6.5 version for getting important information on what users were up to quickly, but this appears even worse. I wrote a beefed up version of sp_who2 for 6.5, and on Friday started looking at a version for SQL7 - I was that disconsolate!
If there is someone out there who can effectively manage SPID activity on a server using the Enterprise Manage, please tell me how you do it...
Hello! My login is dbo for a database located at a remote server(SQL server7.0).Can I run the stored procedures of that database by accessing remotely.Also I have to manage that database from here,what limitations that I will have if I am not an SA for that server?Any help is appreciated.I am operating from NT workstation4.0.
Can anyone shed more light on the following in SQL 2K
1. Peg lookup tables in memory so that they dont get swapped out 2. Mark tables as readonly (force all queries against it not to issue shared locks) 3. Peg frequently used procedures in memory
A kick in the right direction will be sincerely appreciated
I'm new to MS SQL and would like to get your opinion on how it's possible to automatically manage transaction log growth. I've read the following on the topic:
"When Microsoft SQL Server finishes backing up the transaction log, it truncates the inactive portion of the transaction log. This frees up space on the transaction log. SQL Server can reuse this truncated space instead of causing the transaction log to continuously grow and consume more space. The active portion of the transaction log contains transactions that are still running and have not completed yet."
I'm backing up the transaction logs on a daily basis. Still one of the logs grew up to 130Gb even though I have shrunk it in the past. How can I manage the growth automatically without shrinking the log files manually every time they grow beyond a certain threshold?
I'm new to MS SQL and would like to get your opinion on how it's possible to automatically manage transaction log growth. I've read the following on the topic:
"When Microsoft SQL Server finishes backing up the transaction log, it truncates the inactive portion of the transaction log. This frees up space on the transaction log. SQL Server can reuse this truncated space instead of causing the transaction log to continuously grow and consume more space. The active portion of the transaction log contains transactions that are still running and have not completed yet."
I'm backing up the transaction logs on a daily basis. I believe that all or most of the portions of the log are inactive by the time the backup starts. Still one of the logs grew up to 130Gb even though I have shrunk it in the past. How can I manage the growth automatically without shrinking the log files manually every time they grow beyond a certain threshold? Also, how can I check whether some of the log portions are active or inactive?
I am running management studio from my desktop but I think I need sp2 is there a sp2 download for management studio that isnt management studio express?
Hi, I need support for the following problem. It is a teamwork.Suppose 25 databse developer developing a databse.every one make modification (update,delete,insert)to the centralized database.I want that every one its on database copy and make modification to that instead to centerlized database.As source control softwares do(e.g visual source safe).or any other way to manage database in such senerio. Hope any one will help. Thanx in advance.
Let's say I may possibly use two transactions in a script, the secondone will depend on the successful execution of the first one.The following code works. However, I'm wondering if SQL Server 2000has some internal function like @@transaction_status to indicate thestatus of the most recent transaction by the connection. The analogueof @@FETCH_STATUS. Then, my own error tracking code could be omitted.Thanks.-- ENV: SQL Server 2000-- ddlscreate table tblA (col1 smallint, col2 smallint)create table tblB (col1 smallint, col2 smallint)create table tblX (col1 char(1), col2 varchar(20))declare @errorCode tinyIntset @errorCode = 0begin transaction fTraninsert into tblAvalues (7,1);insert into tblBvalues (8,0);-- we know this guy will failinsert into tblXvalues ('ab','abcdefge')If (@@error <> 0)beginselect @errorCode = 1endif (@errorCode = 1)rollback transaction fTranelsecommit transaction fTranif (@errorCode = 0)pseducode: start second transaction here ...elseprint 'fTran failed.';RETURN
Hi:I have a Point-of-sale application that uses SQL Server2000 for the backend.Basically, the users perform various functions boiling down to login (checkpassword from a table) and data entry (insert a food entry). Previously, Iwould open a new ADO 2.7 connection to the database each time one of thesetypes of database accessing functions needed to be performed - but I noticedthat sometimes the DB would freeze the application for 20 seconds or so - oreven cause a timeout error.To fix this, I open a DB connection when the application first starts,keeping it open for the life of the application - each time a function needsto access the DB, it just uses the applications (global) connection that isconstantly open and connected.This seems to have fixed the problem, however, I am curious, is this an OKway to handle the connections - keeping in mind that there are four separatestations - each running the application - at the same time. Therefore, Ihave 4 constantly open connections at the same time.Thanks and regards,Ryan Kennedy
I just installed the Developer Edition of SQL Server 2005 on my machine and updated it to all available patches through Microsoft Update. I cannot find the SQL Server Management Studio on my machine? How can I get this? Help mentioned where its exe is located but I cannot find it there either.
i have a problem regarding sql management studio....
1. I can't create new server, i'd follow the tutorial in video. but it doesnt work. or may be i must install the IIS?
2. i create a new database named sample (sql management studio) and add some tables and sort of data. how can i deploy this database so that i can bind/connect to my program.
We are use Vista X64 and SQL-Server 2005 X64 Developer Edition. We are able to connect to a sql2005 server x32 server using SQL 2005 management studio, 32-bit version. From the x64 box (vista x64 with sql x64), we are able to connect to the SQL 2005 32-bit server version using sqlcmd and telnet. But, we are having issues connecting to the 32-bit version of SQL 2005 using the x64 sql management studio GUI. I look all over the internet and the SQL BOL and I was not able to find any compatibility issues with the SQL Management Studio x64 been documented. I am thinking that the reason for the issue is because the SQL management studio is trying to connect using native x64 client drivers. If that is the case, is there another method of connecting to a x32 SQL server. I see that the only way to approach this issue is to install the 32-bit version of the SQL client tools on the x64 system. Thanks
P.S. all servers are using SQL SP2 ( no Cumulative Update 4)
hi.. i have like 50 ssis packages,, most of all have the samne conexion to my target server.,, the user an pwd i'm using is the same for all of them... but the pwd has been changed because of security rules,., the result: these packages will no longer execute correctly .. is there anyway i can change this conexion for all the packages without doing it manually? and if so.. how??
How can I get sql Management Studio (2005) to use Sql Compact 3.5? It's been working fine with 3.1, but now when I upgrade my own code to use 3.5 and create a new DB then management studio says it can't open it as it's the newer version (3.5xxx and it wants 3.0xxxx)
Exact text is:
You are trying to access an older version of a SQL Server Compact Edition database. If this is a SQL Server CE 1.0 or 2.0 database, run upgrade.exe. If this is a SQL Server Compact Edition 3.0 or later database, run Compact / Repair. [ Db version = 3505053,Requested version = 3004180,File name = C:foo.sdf ] (SQL Server Compact Edition ADO.NET Data Provider)
Installed SQL 2005 standard but the management tools did not install. The admin downloaded the SSMSE (Express version) which does not allow us to manage Analysis Services. We've tried un-installing the SSMSE and then tried to install from the Client Components on the installation disc, the Management console and it doesn't install. Any ideas on how to get the full version installed? Re-installing SQL Server 2005 is not an option as it's been configured and data is now residing in databases.
I have been working this for 2 days on my XP SP2 machine, AHHHHH !!
I tried running the SQL Server 2005 Tools install, and kept getting SQL configuration checker error with WMI. What finally got me around that was installing VS 2005. {without SQL Express} Ran the tools install, but not Management Studio, only the Configuration Tools on my menu. What the heck, tried running the full install, got the database engine, but still no Management Studio.
Tried uninstalling everything, everything is gone except the database engine.
Tried re-installing, still no luck.
Tried the command line to fix the shortcut to management studio as detailed in the setup help file:
NO LUCK. This is absolutely crazy, what year is this. It's as if something the setup program see's on my machine is blocking the install of management studio.
