How To Trace Sql Requests

Apr 5, 2006

Folks,

I have been hunting for a way to trace sql requests going to/from the sql express server (from VS.2005 using asp.net). I.E., I want to see the raw SQL commands that asp.net is generating.

Can anyone point me to a tool or article? Thanks,

--stuart

View 1 Replies


ADVERTISEMENT

Requests Timing Out A Lot

Mar 27, 2008

Hi. I'm new to SQL Server programming. I'm using it at my new job for the first time and catching on quickly. I've run into a problem where I run a request via interactive query and it times out. It's really annoying because it seems to happy a lot. Is this just a memory issue with my machine (it has 2.8 GB of RAM) or there a way around it?

Thanks!

View 12 Replies View Related

100,000 Lock Requests/sec

Jul 23, 2005

I'm monitoring one of our servers, and on the whole it is performingwell. However, I'm puzzled by the number of LockRequests/sec thatPerfmon is recording. We frequently see values exceeding 50,000 andthe current peak is 533,616 (the average, as I type this, is 35,102).There are only 40 users on the system.sp_lock shows nothing like this number of locks; it shows somethingof the order of 30 locks maximum for each execution, which seems farmore reasonable.SQL Profiler seems to back up the Perfmon values; it records hundredsof "Lock Acquired" events per second during these peak periods.For example:NO. OFLOCKS OBJECT STARTTIME===== ====== ======================678User_T2005-04-15 09:03:22.863931User_T2005-04-15 09:03:22.877924User_T2005-04-15 09:03:22.89316EnquiryUser_T2005-04-15 09:03:22.893961User_T2005-04-15 09:03:22.910820User_T2005-04-15 09:03:22.9234NULL2005-04-15 09:03:22.923828User_T2005-04-15 09:03:22.9404NULL2005-04-15 09:03:22.940734User_T2005-04-15 09:03:22.957Can anyone think why such a comparatively small system should generatethese numbers of locks? Why does sp_lock NOT show the same level oflocking?

View 4 Replies View Related

SSIS Requests...

Jun 21, 2005

May be it's too late, but I think this requests could be scheduled at least

View 145 Replies View Related

Lock Requests/sec Too High?

Mar 21, 2008

Hi:

one production server DB is getting slower... (SQL2K sp4 ent)
1. dbcc checkdb(abc) with 0 errors
2. no blocking
3. no abnormal in sql log and event system log
4. only found one crypt32 auto update fail last night.

the Lock Requests/sec is kind high from 5400 to 15400 on 0.01 scale. max is from 57611 to 155411.

Could I increase the locks assigned to sql and what is the best way for it?

thanks
david

View 1 Replies View Related

Intercepting Connections Requests

May 13, 2008

Hello,
You help is very much appreciated.
I have an Intranet environment that contains tens of apps that use a specific database.
I want to create an Intranet test environment (which will use a test database), by basically copying the existing Intranet environment to a new location.

* I cannot change the connection strings in the applications level since each app stores it differently (some store it in Web.Config, some hard coded, etc....).


Then, have a layer that sits between the Intranet Apps and SQL SERVER (or inside SQL SERVER itself), that will intercept the connections requests.
Once intercepted, the code will check if the connection request comes from Intranet Test environemnt, and if so, change the connection string on the fly to point to the test database.


The question:
Is there a way in SQL SERVER 2005, to intercept connections, and then, based on the application that requested the connection, modify the connection on the fly (so that if the calling app is from test_Intranet – intercept the connection and change it to point to a test database, otherwise leave the connection as it is (live database).

Thank you,
Roy

View 2 Replies View Related

Package Configurations - Some Requests

Sep 5, 2006

 

To any Microsoft SSIS developers reading this forum, some requests:

1) do NOT allow a package to run if it has "package configurations" enabled and one or more XML files with configurations cannot be found;

2) update the properties window with the properties read from the "package configurations";

3) allow relative paths in the "package configurations" locations (relative to the package location)

Thank you :-)

View 2 Replies View Related

IO Requests Taking &> 15 Seconds To Complete (was Hi, I'm New, And I Need Help)

Nov 28, 2006

i have an aplication with any problems, the aplication is hang and in the log is

SQL Server has encountered 1 occurrence(s) of IO requests taking longer than 15 seconds to complete on file [d:Program FilesMicrosoft SQL ServerMSSQLdata empdb.mdf] in database [tempdb] (2). The OS file handle is 0x000003DC. The offset of the latest long IO is: 0x00000016930000 and the aplication log is

E R R: [Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionWrite (WrapperWrite()). NUMERO -2147467259 FUENTE Microsoft OLE DB Provider for ODBC Drivers

can yu help me

View 4 Replies View Related

Can SQL Service Broker Persist Requests?

May 17, 2007

I have a scenario where we want something like a message bus. We can have multiple clients sending in events and would like a way to

i) persist those events

ii) Send out the notifications to the subcribers (this would be some C# services)



What is the best way to do this? I know that we can build something from scratch using WCF Publish-Subscribe. But i was interested in knowing if I can leverage SQL Service Broker to do the work.



View 8 Replies View Related

Submitting Report Requests From .NET Application

Feb 13, 2007

Hi,

One of my client want to shift his reporting to SSRS. He wants to submit his report requests to SSRS. He wants the report should run at the reporting server side (not on client system) and output should be exported to a folder on server.

I am some what successful in submitting the report requests using subscriptions. But I have no idea to retrieve the requests from SSRS with the execution status.

I have to display all submitted reprot requests with execution status (success or fail) in a data grid and user selects one report to see the out file. Where can I get this information?

And how can I create a subscription that runs immediatly after submission. (without any delay)?

Help me please!!!

Thanks in advance, Gouri Sankar

View 4 Replies View Related

Mssql 2005 Problem, To Many Requests, Need To Optimize

Feb 2, 2007

Hello, I have a bit of a problem. Some of my pages has way to many database requests, some pages upto 70 requests,and the loading time can be all the way up to 12seconds because of the many requests. So i am trying to optimize it abit.What i want to know if how to send several ID's to the database and collect the result from all of the ID's, i have a stored procedure like this:
public DataTable User_GetUsernameTypeTwo(string strUsername){OpenDBCon();mCom.Parameters.Clear();mCom.CommandText = "Profile_GetUsernameTypeTwo";mCom.Parameters.Add(new SqlParameter("@UserName", SqlDbType.NVarChar, 20));mCom.Parameters["@UserName"].Value = strUsername;myAdap = new SqlDataAdapter();myTable = new DataTable();myAdap.SelectCommand = mCom;myAdap.Fill(myTable);CloseDBCon();return myTable;}
To this i send a username and in return i get info about the user that then is presented on the page. If i have a gridview on the page with 20 posts, then it needs to make 20 requests to this file in order to collect all the info for all the users. Then i have one just like the one above that collects the photos of all the users. So my first thought was that i merge these two together, witch works perfect, reduces the database calls by around 40%. Then i thought, perhaps can i get all the info from all the users in 1 request, to reduce the load on the database even more, my problem is: How can i rewrite the one above to accept lets say 50 usernames (1 username can max have 20characters), and return the info from all of them. Since i use a stored procedure i cant with ease use WHILE (username = xxx) AND (username = yyy) AND (username = ccc), then i would have to add 50 Parameters and add each username to a seperate parameter and then look if the parameter is null or if it contains a username. So i need to find another way to send the usernames, so the sqlserver can add them to the where clause, perhpas using IN?
This is the sql server store procedure (it works perfect, when its one user i am requesting info about), i am using FULL OUTER JOIN because ALL fields i request can be NULL:
ALTER PROCEDURE [dbo].[Profile_GetUserpopupInfo] -- Add the parameters for the stored procedure here@UserName nvarchar(20)ASBEGIN-- SET NOCOUNT ON added to prevent extra result sets from-- interfering with SELECT statements.SET NOCOUNT ON;SELECT settings_username.color, settings_username.pic1, settings_username.pic2, profile_profilephoto.imageurl, profile_profilephoto.alttext FROM settings_username FULL OUTER JOIN profile_profilephoto ON profile_profilephoto.username = settings_username.username AND (profile_profilephoto.approved = 1) WHERE (settings_username.username = @UserName)END
Anyone got any idea of how to send a bunch of usernames to this stored proc? (it must be efficient since there is alot of users)
Patrick

View 1 Replies View Related

Large Numbers Of Orphaned/expired Requests

Mar 30, 2007

We are experiencing a situation where the SRS (2000 SP2) report server will no longer render reports. In the log file, there are many instances of

w3wp!runningjobs!434!3/23/2007-10:12:57:: i INFO: Adding: 8 running jobs to the databasew3wp!runningjobs!434!3/23/2007-10:13:57:: i INFO: RunningJobContext.IsClientConnected; found orphaned requestw3wp!runningjobs!434!3/23/2007-10:13:57:: i INFO: RunningJobContext.IsExpired; found expired requestw3wp!runningjobs!434!3/23/2007-10:13:57:: i INFO: RunningJobContext.IsExpired; found expired requestw3wp!runningjobs!434!3/23/2007-10:13:57:: i INFO: RunningJobContext.IsExpired; found expired requestw3wp!runningjobs!434!3/23/2007-10:13:57:: i INFO: RunningJobContext.IsClientConnected; found orphaned requestw3wp!runningjobs!434!3/23/2007-10:13:57:: i INFO: RunningJobContext.IsClientConnected; found orphaned requestw3wp!runningjobs!434!3/23/2007-10:13:57:: i INFO: RunningJobContext.IsExpired; found expired requestw3wp!runningjobs!434!3/23/2007-10:14:57:: i INFO: RunningJobContext.IsClientConnected; found orphaned requestw3wp!runningjobs!434!3/23/2007-10:14:57:: i INFO: RunningJobContext.IsExpired; found expired requestw3wp!runningjobs!434!3/23/2007-10:14:57:: i INFO: RunningJobContext.IsExpired; found expired requestw3wp!runningjobs!434!3/23/2007-10:14:57:: i INFO: RunningJobContext.IsExpired; found expired requestw3wp!runningjobs!434!3/23/2007-10:14:57:: i INFO: RunningJobContext.IsClientConnected; found orphaned requestw3wp!runningjobs!434!3/23/2007-10:14:57:: i INFO: RunningJobContext.IsClientConnected; found orphaned requestw3wp!runningjobs!434!3/23/2007-10:14:57:: i INFO: RunningJobContext.IsExpired; found expired request

What could be causing this? The reports are making queries through an OLE DB provider. There are no scheduled jobs, and the load doesn't seem that heavy.

View 1 Replies View Related

I'm Flooding My SQL Server With INSERT / UPDATE Requests. How Do I Optimize?

Sep 29, 2005

I have an application that calculates a bunch of numbers and then inserts them into a table (or updates a record in the table if it exists).  In my test environment it is issuing 100 insert or update requests to the server per second and it could run for several hours.After a the first several hundred requests, the SQL server is bogging down (processor at 90-100%) and the application slows down while it waits on SQL to update the database.What would be the best way to optimize this app?  Would it help to loop through all my insert/update requests and then send them as one big batch of statements to the server (per 1000 requests or something)?  Is there a better way of doing this?Thanks!

View 1 Replies View Related

Recommendation Requests: Learning MS SQL Server For Sybase DBAs

Feb 14, 2006

Hello,

I have been working as Sybase DBA for 5+ years, and I would very much like to add MS SQL Server to my resume. Given the common roots of the two RDBMS, it seems that the learning curve would not be as sharp as if I were going to learn Oracle or DB2. Can anyone out there know of any books that are geared toward learning MS SQL Server from a Sybase DBAs perspective?

Thank you,

- Chris Merz

View 3 Replies View Related

Server And Database Role Requests For Normal User

Jun 5, 2007

Hi,

I want to know how to assign a normal user to take backup,Restore and attach and detach the database in sqlserver2000.

Please can anyone help me to find out which server role or database role will suites my requirements.

Regards
Md S.Hassan

View 1 Replies View Related

SQL 2012 :: Profiler Event For Bulk Load Requests?

Jan 27, 2015

For Bulk Load requests in SQL server, Are there any specific profiler event? Like the one we have for RPC RPC:Starting and for Batch Requests, we have SQL:BatchStarting.

Are Bulk Load requests that are being monitored through Profiler captured as SQL:Batch... events at the backend?

Are there any new features added in 2012 or 2014 to identify a Bulk request submitted through bcp.exe utility or any other sqlbulkcopy program?

View 1 Replies View Related

Integration Services :: Database Manager Is Not Able To Accept New Requests

Jul 31, 2013

Working on this issue ... SSIS package trying to load data from DB2 to SQL ....

IBM OLE DB Provider for DB2"
Hresult: 0x8004D01C
Description: " SQL1224N The database manager is not able to accept new requests, has terminated all requests in
progress, or has terminated the specified request because of an error or a forced interrupt. SQLSTATE=55032

SSIS Error Code DTS_E_PRIMEOUTPUTFAILED -
The PrimeOutput method on component "OLE DB Source" (1)
returned error code 0xC0202009. The component returned a failure code when the pipeline engine called PrimeOutput().

The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing.

View 2 Replies View Related

Transact SQL :: How To Restart Or Take DB In Single User Mode By Honoring All Requests

Oct 8, 2015

some times i need to take db in single user mode , which can be done using following

ALTER DATABASE xyz
SET  SINGLE_USER WITH NO_WAIT

this has other options but each one has some problems like if any single window is open at any location etc etc.

Q1)so the need is i want to honor running transaction from  msss or any application then i want db to get into single mode so that i can perform my task.

Q2)  some times i need to restart db as it becomes slow , i am trying to find the reason primarily i have seen it  is memory.so i want to restart my db honoring all requests.

View 6 Replies View Related

Whats Does This Mean ??? --- SQL Server Has Encountered 1964 Occurrence(s) Of IO Requests Taking Longer Than 15 Seconds

Sep 13, 2007

Hello,

I see the following error on the sql server log of one of our sql servers running sql 2000 with sp4.
SQL Server has encountered 1964 occurrence(s) of IO requests taking longer than 15 seconds to complete on file [h: empdb.mdf] in database [tempdb] (2). The OS file handle is 0x00000534. The offset of the latest long IO is: 0x0000002b09e000


Any idea as to what might be causing this error. Appreciate any comments.

Thanks!

View 3 Replies View Related

The Number Of Requests For XXXServerXXXUser Has Exceeded The Maximum Number Allowed For A Single User

Oct 15, 2007



I have created a local user on Report Server Computer and the user has the administrative rights.
When i try to connect Report Server (http://xxx.xxx.xxx.xxx/reportserver) with this user's credantials. (ReportServer directory security is set -only- to Basic Authentication. ).
I get the following error.


Reporting Services Error
--------------------------------------------------------------------------------

The number of requests for "XXXServerXXXUser" has exceeded the maximum number allowed for a single user.
--------------------------------------------------------------------------------
SQL Server Reporting Services


Then i try to login using a different user with administrative rights on the machine, i can logon successfully.
The system is up for a month but this problem occured today?!? What could be the problem?!?

View 2 Replies View Related

How Do I Trace In Sql 7?

Jan 5, 2000

I couldn't find a "sql trace" utility like in sql 6.5... Does anybody know how/if I can do this?

View 2 Replies View Related

SQL Trace

Dec 27, 2003

if i dont use the trace to record all the sql transaction. and someone execute the delete command to delete one of the table (ofcourse the person have high enough permissions to do that). is there anyway i can find out who that user's ID is to run the deleted ?? Thanks:D :p

View 2 Replies View Related

How To Trace SQL

Jun 21, 2004

Hi,

I'm trying to debug a vendor package and would like to turn on JDBC trace (either client or server side). The only information I found is DBCC TRACE which seems not very useful (I even don't know where the trace result located). Any help is appreciated!

Env: Windows Server 2003 & SQL Server 2000 8.00.818.


Jeff Li

View 5 Replies View Related

How To Trace MS-SQL ....

Feb 21, 2007

Guys,


How to trace/find out some one has dropped a database from my QA environment? Unfortunately we havent enabled the trace on this server.
We havent find any useful information from SQL Server logs also.

Can any one reply me how to find the details of who dropped the DB, when? is there any query/SP/command/tools avaialble?

Regards
BSR

With Regards
BSR

View 5 Replies View Related

Trace

May 17, 2007

hi all..
i have 2 tbl..

-- Prepare sample data
DECLARE@tbl1 TABLE (box varchar(10), loc varchar(5) )

INSERT@tbl1
SELECT'P1', 'aa' UNION ALL
SELECT'P1', 'bb' UNION ALL
SELECT'P1', 'aa' UNION ALL
SELECT'P3', 'cc'

DECLARE@tbl2 TABLE (box varchar(10), loc varchar(5) )

INSERT@tbl2
SELECT'P1', 'aa' UNION ALL
SELECT'P3', 'cc'

--expected result
SELECT 'P1' as box, 'aa' as Location, 'aa' as HeaderLoc UNION ALL
SELECT 'P1' as box, 'bb' as Location, 'aa' as HeaderLoc
how do i trace from @tbl1, that has 1 Box with more than 1 Location?
in this case P1 has 2 distinct location (aa & bb).. and left join in the loc from @tbl2 just to retrieve the loc for that box..

~~~Focus on problem, not solution ¯(º_o)/¯ ~~~

View 6 Replies View Related

Trace SQL

Jul 23, 2007

How do you set up the trace in SQL?

thanks


sorry, I am an Oracle guy trying to learn SQL

View 1 Replies View Related

Help With Trace

Jul 20, 2005

Hello:I am working with SQL Server 2000. I have a stored procedure that creates 3temporary tables (#temp1, #temp2, #temp3). When I view the trace of thestored procedure I see entries that have Object Created #temp1, ObjectCreated #temp2, Object Created #temp3. How can I fix the trace so it doesnot report any objects that get created in the tempdb.Any help will be appreciated.Alee

View 1 Replies View Related

ASP.Net Trace File

Jul 2, 2004

When we enable tracing for a web application where exactly the file or content of the file "Trace.axd" saves?

View 4 Replies View Related

Trace Flag Help

Apr 2, 2001

Hi,
I'm trying to use trace flag 1204 to get some detailed deadlock information
In EM, I add startup parameter -T1204, and then I stop and start the server.
I run two jobs that I have setup to deadlock, and they do. But no information about the deadlock is in my sql error log? anyone know what I am doing wrong? thanks.

View 1 Replies View Related

Trace Flags

May 1, 2001

Hi ,
I want to trace the deadlock information. I am enabling trace flags 1204 ,1205. Is there any difference in setting these trace flags by using DBCC
TRACEON and by setting them at command prompt by statrting the SQL server with SQLSERVR command. Actually i don't want to bring the server down. I want the information to be logged to Error log. Any help is greatly appreciated.

View 1 Replies View Related

Table Trace

May 29, 2001

Hi There,
Is there any way to identify how many times a table is accessed by different users in a day from a database.

Thanks,
Madhu.

View 3 Replies View Related

Trace On Deadlocking

Jun 21, 2001

Hi all,

I was wondering how much of an overhead would Running this
trace (1204) have over the system. Will my perfomance
degrade significantly. If yes, by what percentage ???

The trace is 1204 to keep a watch on DeadLocking

I am running this command
C:mssql7innsqlservr -T1204 /dc:mssql7datamaster.mdf

How much performance degrade are we talking about here ?
The Application is Peoplsoft and the db sizes is about 10
Gb !!


Regards

Girish

View 2 Replies View Related

Trace Out The USER

Jun 27, 2000

SUPPOSE A THIRD PERSON WHO (MODIFIES THE STRUCTURE OF A TABLE) OR (DOING SOME MODIFICATIONS ON A CERTAIN COLUMN), HOW THE SQL SERVER DBA WILL FIND WHO HAS DONE THIS. WHETHER THESE MODIFICATIONS WILL BE STORED IN SYSTEMS TABLE?. THIS IS MY QUESTION. CAN ANYBODY GIVE SOLUTION TO THIS PLEASE?. THANKS ---- Srinivasan.

View 2 Replies View Related







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