In the Event Viewer:
Source: Application Error
Category: 100
Event ID: 1000
Faulting application w3wp.exe, version 6.0.3790.3959, faulting module kernel32.dll, version 5.2.3790.4480, fault address 0x000000000000dd50.
This error is happening on my background-app server (not web server). It's happening every 3-5 minutes.
What's the problem in laymen's terms? And then the solution? :)
Or if this isn't enough info, how can I troubleshoot?
I'm setting up a home office for telecommuting to my employer. I'm a software engineer. I need access to both our Dev servers (located at the employer) and our Production servers (located at our 3rd-party hosting company).
I'm under the impression that I can VPN into only one network at a time (i.e. only my employer or the hosting company). But that's not acceptable because I need access to both at the same time to do my job. For instance, if I need to move a file from Dev to Production. Or run a SQL query on Dev and compare the results with Production.
How can I access both environments? Or if the answer is highly dependent on some things, what details do I need to get? Does the hosting company need to change some config settings or whitelist my home IP or something?
My machine is Windows 7 with Cisco VPN client. And our servers are Windows 2003. I work in a small company, so there is little bureaucracy and IT staff.
I need to restore about 1000 backups with the latest diff (for about 1000 databases). Some data was deleted last night in one column of a table. So I need to run a script on each restored vs current database to repair the data loss.
I know how to get a restore script via the Sql Server Mgmt Studio GUI, but how can I get a restore script for all the databases on the server?
Perhaps, there is a SELECT statement I could run to get full backup file path and latest diff file path for every database on the server. If you know how to do this, let me know.
(And yes I know to just do restore a database one at at time, and then delete to conserve space, but I still need to automate because there are about 1000 databases).
I'd like to create a settings file for my logman command. I expect to have lots of perfmon counters.
Is there any easy way to get all the perfmon counters' exact text anywhere?
The only thing I thought of was to create a Perfmon Counter Log through the GUI and then export the list of selected counters--but I don't see an export option! I guess I could manually copy what I see on the screen, but that seems inefficient. I'm going to be dealing with tens of counters.
Maybe there is a list somewhere? That'd be easier to copy and paste from.
I'm setting up my first logman counter. But it's not working! There is some file or folder permissions problem. Or maybe I wrote the create-counter statement wrong.
Here's my counter commands:
logman create counter BillTest -si 30 -v nnnnnn -max 200 -o "C:\Temp" -c "\Processor(*)\*" "\Memory(*)\*" "\LogicalDisk(*)\*"
logman start BillTest
The first command works. It says counter creation successful.
The second command fails:
Collection "BillTest" did not start, check the application event log for any errors
Here's the error in the Event Viewer:
The service was unable to open the log file C:\Temp_000001.blg for log BillTest and will be stopped. Check the log folder for existence, spelling, permissions, and ensure that no other logs or applications are writing to this log file. You can reenter the log file name using the configuration program. This log will not be started. The error returned is: Access is denied.
I verified that C:\Temp exists. I'm not a permissions guru, but I did set all the accounts in the security tab of that folder to "full control." Still, the logman start command failed with the same error.
I noticed that it was trying to write to C:\Temp_000001.blg instead of C:\Temp\000001.blg. That might be part of the problem. So, I tried to update my counter to "C:\Temp\" instead of "C:\Temp", but that failed with a path-invalid error. Also, all the examples I saw online used did not put a trailing slash. So, no dice there.
I tried this on my machine (Windows XP) and my dev server (Windows Server 2003). Both failed with the same error.
How can I fix this?
The counter, Process(sqlservr)\% Processor Time, is hovering around 300% on one of my database servers. This counter reflects the percent of total time SQL Server spent running on CPU (user mode + privilege mode). The book, Sql Server 2008 Internals and Troubleshooting, says that anything greater than 80% is a problem.
How is it possible for that counter to be over 100%?
Or should perfmon be limited to a Dev/QA server with load tests that simulate production activity?
I'd like to run perfmon for two days (like Sql Server master Brent Ozar suggests) to get an overall feel of my web app's database performance.
This would save me the redundant ON MyCatalog phrase when I create full-text indices.
For example,
CREATE FULLTEXT INDEX ON MyTable
(
MyField1,
MyField2,
MyField3
)
KEY INDEX PK_MyKey ON MyCatalog /* I want MyCatalog to be default, so I don't have to specify*/
WITH CHANGE_TRACKING AUTO
With MyCatalog set as default catalog, I wouldn't have to specify ON MyCatalog every time I want to create a full-text index. So how can I make MyCatalog default on this database?
I tried to create a full-text index on my new full-text catalog and got this error:
Msg 9967, Level 16, State 1, Line 1
A default full-text catalog does not exist in database 'foo' or user does not have permission to perform this action.
FYI--
Full-text Index -> option)What do I need to do in Sql Server 2005 and/or in Windows Server 2003 to get permissions?
Please be thorough (assume I am a sysadmin n00b). Thank you.
I failed to connect to a production SQL server. My administrator reset my password, and told me what it was.
SQL Server Management Studio gives me this error: Login failed for user 'Bill'. Reason: The password of the account must be changed. (Microsoft SQL Server, Error: 18488)
So, how can I reset my password?
I tried terminaling into the server with this account, but it said that account doesn't exist. So I guess it's not a regular server account--just SQL server. (if that helps)