Whats does this mean ??? --- SQL Server has encountered 1964 occurrence(s) of IO requests taking longer than 15 seconds

SQL Server Database Engine

Index ‹ SQL Server

- Previous
  - 1
    - Disaster Recovery - How to verify my 2005 standard databases using 2005 express How does one fix the security problems in the second server Is there a formula or a list of parameters to change Tag: Whats does this mean ??? --- SQL Server has encountered 1964 occurrence(s) of IO requests taking longer than 15 seconds
  - 2
    - How can we create cubs in sql server 2005 BI Can you send me the notes on this. this link http://www.databasejournal.com/features/mssql/article.php/3553971 shows in SQL Server 2000 Analysis Services but i need SQL Server 2005 Analysis Services Can you help me on this........PLZ..... Tag: Whats does this mean ??? --- SQL Server has encountered 1964 occurrence(s) of IO requests taking longer than 15 seconds
  - 3
    - Can't Get SQL Authentication to work With XP Pro SP2 in very simple test case Thanks for the input. Wow. Good to know I wasn't completely blowing it....it looked too easy. So, maybe it will work on the Windows 2003 VPS Server I'm renting...I guess I'll have to give it a try. But maybe it tells me I need to consider why SQL Authentication is critical to this app. Grazie! Tag: Whats does this mean ??? --- SQL Server has encountered 1964 occurrence(s) of IO requests taking longer than 15 seconds
  - 4
    - Using Array Variable in ForEach Loop Container Thanks Ravi, it helped me so much, now I know what the "Traverse subfolders" is for :) One more question Ravi, when I put the value into variable, can I get that value inside Script Component my plan is establish the flat file connection inside Script Component and get the data row by row using Synchronous method and push it into database. Is that a problem Thanks in advance. Tag: Whats does this mean ??? --- SQL Server has encountered 1964 occurrence(s) of IO requests taking longer than 15 seconds
  - 5
    - Database corrupt on power loss Ilya, Thanks for the reply! We use the database as follows: We open a connection using SqlCeConnection.Open() We prepare a command using SqlCeCommand.Prepare() We write to database using SqlCeCommand.ExecuteNonQuery() We keep same connection open all the time while we are writing. At this time we don't read from database, we just write. The operating system is XP Embedded. The file system is NTFS. I am not sure if there is any corruption in the file system but I assume it is not since I just delete the bad database and restart the test and everything goes back to normal. How would I check to see if there is any file system corruption I will check your suggestion about disabling HDD write cache. I doubt that it is disabled. Tag: Whats does this mean ??? --- SQL Server has encountered 1964 occurrence(s) of IO requests taking longer than 15 seconds
  - 6
    - tfs installation issue !!!!!!!!1 i had SP1 of visual studio and TFS installed on my server but it didnt work and i had a server failure, so i removed the SP1 after doing this i had this error: " Team Foundation Server does not exist or is not accessible at this time. Technical information (for administrator): HTTP code 503: TF30059: Fatal error while initializing web service " after searching on line i found that there is problem in version number of Microsoft.TeamFoundation.VersionControl.Server.dll file so i changed it to be compatible with TFS version number. by dowing this the following erro appeared " Please contact your administrator. There was an error contacting the server. Technical information (for administrator): HTTP code 500: Internal Server Error " after that i removed the TFS and tried to reinstall it on the same server, here i had the following error: "Error 28922.TFServerStatusValidator: ErrorConnectingToDatabaseWhenImpersonated - Most likely the service account doesn't have permission to access TFS database (because the tool succeeded connecting to the TFS database as the current user - user running setup)" and here im totaly stuck , coz the user of services can connect to sql server , i used the sevice account to connect to sql server and connection was established successfully. Tag: Whats does this mean ??? --- SQL Server has encountered 1964 occurrence(s) of IO requests taking longer than 15 seconds
  - 7
    - Connection Error from ASP.Net under IIS: provider: Named Pipes Provider, error: 40 (1) Is this remote connection or local connection -Remote connection (2) Is the account that runing your visual studio.net the the same as your IIS. Do you impersonate client connection in IIS -Same account, windows authentication. No impersonation (3) Can you make direct connection to your backend sqlserver from your virtual studio or sql server management studio -Management Studio works, Cassini works.. IIS does not (4) Can you try connecting using TCP instead If not, what is the error code TCP gives "server actively refused connection" error Tag: Whats does this mean ??? --- SQL Server has encountered 1964 occurrence(s) of IO requests taking longer than 15 seconds
  - 8
    - Cant restore the database backup in SQL server 2005? Hi, System.Data.SqlClient.SqlError: There is insufficient free space on disk volume 'C:\' to create the database. The database requires 83679641600 additional free bytes, while only 46151348224 bytes are available. (Microsoft.SqlServer.Smo) Thanks, S.Shyam. Tag: Whats does this mean ??? --- SQL Server has encountered 1964 occurrence(s) of IO requests taking longer than 15 seconds
  - 9
    - How to move Full Text Catalog SQL 2005??? The documentation is close but not detailed or correct enough for me to try and hack through it on a production box. In fact the sixth step is causing this error: Msg 259, Level 16, State 1, Line 1 Ad hoc updates to system catalogs are not allowed. I even ran the follwoign command to allow updates to the catalog. USE MailMeter ; GO EXEC sp_configure 'allow updates' , '1' ; RECONFIGURE WITH OVERRIDE ; After searching Google it would seem that system catalog updates is not even possible even when using this option. Please somoene tell me how to move the Full Text Catalog!!! I am floored that there isn't any documentation that I was able to find in regards to this action. Tag: Whats does this mean ??? --- SQL Server has encountered 1964 occurrence(s) of IO requests taking longer than 15 seconds
  - 10
    - How to programmatically set column mappings of a simple data flow task? Thanks, Jamie, that helped a lot. I have a further question, though. I want to make a script task that will programmatically set the mappings in the subsequent data flow task. That is, I am writing this code in the package, not separate code to create the package. How do I reference the data flow task from within a script task That is, how do I set e in the following code (and actually, the Mainpipe class does not seem to be recognized by the IDE): Thanks for your help! Imports System Imports System.Data Imports System.Math Imports Microsoft.SqlServer.Dts.Runtime Imports Microsoft.SqlServer.Dts.Pipeline Imports Microsoft.SqlServer.Dts.Pipeline.Wrapper Public Class ScriptMain ' The execution engine calls this method when the task executes. ' To access the object model, use the Dts object. Connections, variables, events, ' and logging features are available as static members of the Dts class. ' Before returning from this method, set the value of Dts.TaskResult to indicate success or failure. ' ' To open Code and Text Editor Help, press F1. ' To open Object Browser, press Ctrl+Alt+J. Public Sub Main() ' ' Add your code here ' Dim e As Executable Dim thMainPipe As Microsoft.SqlServer.Dts.Runtime.TaskHost = _ CType (e, Microsoft.SqlServer.Dts.Runtime.TaskHost) Dim dataflowtask As Mainpipe Dts.TaskResult = Dts.Results.Success End Sub End Class Tag: Whats does this mean ??? --- SQL Server has encountered 1964 occurrence(s) of IO requests taking longer than 15 seconds
  - 11
    - suggestions yep i did try data flow task.And in dataflow i used conditional split,lookups etc...but do they transform data using set based or row based..how do i transform data set based Tag: Whats does this mean ??? --- SQL Server has encountered 1964 occurrence(s) of IO requests taking longer than 15 seconds
  - 12
    - Cannot get SSCE 3.5 beta 2 to work Mike, I'm starting to think it has something to do with x64. I'm only getting this error Windows Server 2003 x64 and on Vista x64. However, when I install VS2008 on Vista x86, I have not seen the issue (at least not so far). What platform are you running on Jon Tag: Whats does this mean ??? --- SQL Server has encountered 1964 occurrence(s) of IO requests taking longer than 15 seconds
  - 13
    - Database Mail Command Not Supported - Again Tried that. No joy. Even tried un-installing and reinstalling SQL server (this is a test box) along with SP2. No help there either. My mail guys tell me that no messages get to their SMTP relay. Checked AV to be sure port 25 not blocked. It is OK (McAfee AV Enterprise 8.1. Tag: Whats does this mean ??? --- SQL Server has encountered 1964 occurrence(s) of IO requests taking longer than 15 seconds
  - 14
    - Generate a cube in Standard Edition Ok, i found it, but I want another thing... I am working on a project that require me to build cubes programmatically i.e., using AMO object and C#. I am trying to find a sample that builds cubes using C# in Standard Edition. Tks!!! Tag: Whats does this mean ??? --- SQL Server has encountered 1964 occurrence(s) of IO requests taking longer than 15 seconds
  - 15
    - SQL Server 2000 - Generating new field containing the sum of other rows Hi lkh, Thanks for answering. I have never used the code to create a table yet, but I understand from your code that you are creating a new Table and entering each value "manually" The table with the original data "myTable", has several fields with thousands of data... what should I do Thanks, Aldo. Tag: Whats does this mean ??? --- SQL Server has encountered 1964 occurrence(s) of IO requests taking longer than 15 seconds
  - 16
    - Checking Job Status using T-SQL Look up using [sp_help_job] in Books Online. Tag: Whats does this mean ??? --- SQL Server has encountered 1964 occurrence(s) of IO requests taking longer than 15 seconds
- Next
  - 1
    - Repeat Report Title On EveryPage Any idea on how to do this on Report Builder Tag: Whats does this mean ??? --- SQL Server has encountered 1964 occurrence(s) of IO requests taking longer than 15 seconds
  - 2
    - Cascading Date for Filter my cube is connected to ms excel 2007 Tag: Whats does this mean ??? --- SQL Server has encountered 1964 occurrence(s) of IO requests taking longer than 15 seconds
  - 3
    - Function with Dynamic Column Name without Execute statement Hi Waldrop, I appreciate you , I agree the above work where you have a table with constant no of columns, but as I said the table status gets buildup every month and gets added a new columns. The column have the policy status for the current month. if you look into function select substring (stat_198612 + stat_198701 + stat_198702 + stat_198703, position, 1) as status you have concatenated all columns , looks good, but I am not certain about how more columns I would have after a period of time . if I write a dynamic query , function has end up with schema. I just have added one more record into insert into dbo.policyStatusMap values ('199503', 1) and when I execute select dbo.policyStatus ('AAB', '1409504', '00', '199503') as policyStatus returns me the same result as 'f' where as the policy had a status 'i' for the month and year.......... Tag: Whats does this mean ??? --- SQL Server has encountered 1964 occurrence(s) of IO requests taking longer than 15 seconds
  - 4
    - Digest Authorization on HTTP Endpoint Since on Windows Digest requires a domain controller, I assume that your network environment is already setup correctly to support Digest authentication This is something I do not know - when I talked with IT about it before, they told me it was a developer problem and wouldn't look at it any more. This could very well be the piece I'm missing - what is it I could have them look at The server running the SQL Server is running Windows Server 2003 R2 Enterprise x64 edition, and the SQL Server version is 9.0.2175 Local System: XP Pro SP2, browser I was accessing the wsdl with is IE v6 with all patches updated, and is setup to go through a proxy server. Note that I get the same results if I attempt to create a web reference to it from a project in VS2005, which probably isn't that surprising. I don't have access to the java code that will be accessing the final version, so I was trying go get something working on my end first, before telling the other developer to hit it. I'm not sure about what version of windows the domain controller is running, I'll have to ask around, but won't know that until tomorrow (anyone I could ask is already gone for the day) Tag: Whats does this mean ??? --- SQL Server has encountered 1964 occurrence(s) of IO requests taking longer than 15 seconds
  - 5
    - Query with CASE and NULL values I'm sorry, I think I didn't explain my self. The problem is in the WHERE part, No in the SELECT. When @IDUsuario has a value, then the query return the record with the NULL value, and that is not correct. If I take off or idusuario is null then the record with de NULL value is never return. thanks and sorry my english !. Tag: Whats does this mean ??? --- SQL Server has encountered 1964 occurrence(s) of IO requests taking longer than 15 seconds
  - 6
    - SQLServer Error: 15404 with Active Directory Hi, Raul. Thanks for your reply. I tested the service account's ability to query ADS in this way: On the server, whenever I adjust NTFS permissions on a file or folder and want to add an ADS account or group, I have to supply an ADS username and password to query ADS. I did this using the SQL Server Service account's name and password, and I was able to "check names" in ADS. I'm assuming this is a valid test. Also, in one test, I set the owner of the job to the service account and the job ran. So, it looks like the service account has permission to check itself in ADS, but not other ADS objects. (Assuming the SQL Server Service account is the account actually making the query to ADS.) So, I'm still not certain if I need to adjust SQL Server, Windows Server, or the ADS service account permission to ADS (which I cannot do myself - I'm on a very large ADS with limited rights to objects). Thanks again, -Tony Tag: Whats does this mean ??? --- SQL Server has encountered 1964 occurrence(s) of IO requests taking longer than 15 seconds
  - 7
    - Sql server 2000 - xp_sendmail stored procedure Your first step will be to install Outlook 2000 on the machine that's running SQL Server. It must be the 2000 version, unless you're working with an Exchange server, in which case you can get away with 2002. If you're doing SMTP, then use 2000. Then you have to use the usual right click, Run As to launch the Mail control panel for the service accounts used for both SQL Server, and Server Agent. The control panel will likely be here: C:\Program Files\Common Files\System\Mapi\1033\NT\MLCFG32.CPL. If you don't see it, just search for that filename. Set up the email accounts as necessary. If you like, launch Outlook using Run As to test that it's all working. I'd highly recommend doing this before moving on. After you've got the accounts settings in order, go over to Enterprise Manager, and work your way to Support Services > SQL Mail beneath the server you're working with. Right click the icon in the tree and go to the properties. Pick the name of the MAPI profile that you just set up using the Mail control panel. This will allow xp_sendmail to (hopefully) work. To get Server Agent sending notification mail properly, go to Management > SQL Server Agent, right click and go to properties. Pick the mail profile you set up (note that this mail profile must be one associated with the Server Agent service account). It's kind of a pain to get it all working, but once you do, you'll wonder how you lived without it. Tag: Whats does this mean ??? --- SQL Server has encountered 1964 occurrence(s) of IO requests taking longer than 15 seconds
  - 8
    - Error 500 Takes it's toll It was automatically set up, I checked the permissions in both NTFS and the website's permissions they all checked out fine Tag: Whats does this mean ??? --- SQL Server has encountered 1964 occurrence(s) of IO requests taking longer than 15 seconds
  - 9
    - SQL Server 2005 SP2 (X64 version) Performance issues Is it on the same hardware or different hardware Tag: Whats does this mean ??? --- SQL Server has encountered 1964 occurrence(s) of IO requests taking longer than 15 seconds
  - 10
    - Help: How to improve the speed of Sync. If possible, make the colums shorter to decrease the index size. You could also consider createing the database file server side (including indexes), zipping and downloading, then unzipping on device. Tag: Whats does this mean ??? --- SQL Server has encountered 1964 occurrence(s) of IO requests taking longer than 15 seconds
  - 11
    - TSQL for dependency hierarchy Hi, Thanks for your reply CTE are good if you have hierarchical data In my example what would you say the parent child relationship is Ive tried object_id as below. and it doesnt work. Do you have any ideas please WITH CTEResultDepends ( objectId , spName , levelid ) AS ( SELECT objectId = so . object_id , spName = so . name , levelId = 0 FROM sys.objects so INNER JOIN sys.Sql_modules sc ON sc . object_id = so . object_id WHERE so . type IN( 'P' , 'TR' , 'FN' ) AND sc . definition LIKE @cSearch AND so . name <> @p_cCallName UNION ALL SELECT objectId = so . object_id , spName = so . name , levelId + 1 FROM sys.objects so INNER JOIN sys.Sql_modules sc ON sc . object_id = so . object_id INNER JOIN CTEResultDepends rd ON sc . object_id = rd . objectid WHERE so . type IN( 'P' , 'TR' , 'FN' ) AND sc . definition LIKE '%' + so . name + '%' ) SELECT spName , levelid FROM CTEResultDepends Tag: Whats does this mean ??? --- SQL Server has encountered 1964 occurrence(s) of IO requests taking longer than 15 seconds
  - 12
    - Struggling with dts from .NET Hi everyone, We've got running an vb .net service which throws on-demand .DTSX. Now a new feature has been added: it must be able to launch dts 2000/7.0 too. No problem with that. It works fine using the same thread. Issue comes when we were accostumed to cancel any DTSX execution for sake IDTSEvents interface and OnQueryCancel event. We want to the same but for the old ETL. My wonder is how do the same but related with DTS I attached you this snippet of code which is responsible for launching a dts: Private WithEvents paquete As DTS.Package2 paquete = New DTS.Package2 paquete.LoadFromSQLServer( "SRVDESA1" , , , DTS.DTSSQLServerStorageFlags.DTSSQLStgFlag_UseTrustedConnection, , , , "pruebaenric" ) paquete.Execute() Private Sub paquete_OnQueryCancel( stuff (NEVER ENTRY HERE) Private Sub paquete_OnProgress( ByVal EventSource As String , _ stuff (NEVER ENTRY HERE) Private Sub paquete_OnError( ByVal EventSource As String , _ stuff (NEVER ENTRY HERE) Let me know what's happening Is something related with managed and unmanaged code Any COM feature or something like that Or is only that I've got to define a private class how I did with SSIS and to use one specific interface Primary platform is Framework 2.0 Thanks in advance for your time and information provided, Enric Tag: Whats does this mean ??? --- SQL Server has encountered 1964 occurrence(s) of IO requests taking longer than 15 seconds
  - 13
    - Error when deleting report in Report Manager and SQL Management Studio Yes, I have Service Pack 2 installed for SQL Server 2005 (vers. 9.00.3050) and all the permissions are setup correctly. I'm setup as the browser, content manager, my reports, publisher and report builder. I'm also part of the Administrators group. Lori Tag: Whats does this mean ??? --- SQL Server has encountered 1964 occurrence(s) of IO requests taking longer than 15 seconds
  - 14
    - MSSQLSERVER service error when starting (timely fashion problem) :(( Hi Satya, Thanks a lot for your reply. However we have decided to reinstall the server, if we encounter the same problem i will try your suggestion Many thanks Felix Adhitya Tag: Whats does this mean ??? --- SQL Server has encountered 1964 occurrence(s) of IO requests taking longer than 15 seconds
  - 15
    - date conversion - derived column I've tried that and it still fails. Tag: Whats does this mean ??? --- SQL Server has encountered 1964 occurrence(s) of IO requests taking longer than 15 seconds
  - 16
    - Built-in data types in SQL Express: best practices? Thank you Jens. This helps clear up some things for me. I now know how I want to proceed with my project. Tag: Whats does this mean ??? --- SQL Server has encountered 1964 occurrence(s) of IO requests taking longer than 15 seconds

rk07

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:\tempdb.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!

Top

Re: Whats does this mean ??? --- SQL Server has encountered 1964 occurrence(s) of IO requests taking longer than 15 seconds

Gail Erickson [MS]

See this error message topic http://msdn2.microsoft.com/en-us/library/aa337269.aspx for cause and resolution suggestions.

Top

Re: Whats does this mean ??? --- SQL Server has encountered 1964 occurrence(s) of IO requests taking longer than 15 seconds

rk07

Thank you Gail!

This was very helpful.

Top