Viewing 15 posts - 7,021 through 7,035 (of 49,552 total)
Someone(s) ran backups manually?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 17, 2014 at 7:34 am
random_name (12/17/2014)
• Install extended procedures on the master database
This required sysadmin. The rest do not.
That said, any vendor asking to install extended stored procs on any server I'm in any...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 17, 2014 at 6:04 am
Steve Jones - SSC Editor (12/15/2014)
Given that online essentially starts a transaction, flips two pages, commits, it should be a lot slower.
That's REORGANIZE.
Online rebuild rebuilds the index entirely, creating a...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 17, 2014 at 1:31 am
And bear in mind that you can't downgrade SQL databases. Once the databases are attached to a SQL 2012 instance, they are SQL 2012 databases and will not attach or...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 17, 2014 at 1:22 am
Shafat Husain (12/15/2014)
Checksum and verifyonly essentially performs the same function
They don't do essentially the same thing.
A backup WITH CHECKSUM checks the checksum on each page as it is backed up,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 17, 2014 at 1:19 am
Depends what they do.
However, since DDL triggers only fire on DDL operations, unless you're changing the schema every few seconds, it shouldn't have a major effect.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 15, 2014 at 2:52 am
The ones I love are:
Me: Try this <solution>
OP: That won't work.
Me: Did you try it?
OP: It works.
Usually when the solution is a little non-obvious.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 13, 2014 at 12:31 pm
Definitely a permissions error. Make sure that the SQL service account has full control over folder *and files*
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 13, 2014 at 12:30 pm
Try rebuilding the system databases. If that fixes the system resource problem you can then restore your backups of master, model (if necessary) and msdb.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 13, 2014 at 12:28 pm
Above the top blue bar (the one that starts Home), are some links
Control Panel, PMs, Recent Posts, Popular Topics and finally My Posts. Click My Posts and you get all...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 12, 2014 at 5:13 am
And before that, have a good reason for adding a file to PRIMARY in the first place.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 12, 2014 at 5:11 am
dgbarnes (12/11/2014)
Should I manually enter the security information in the master database then just create the databases and restore from backups, letting Server 2014 perform the upgrades?
Yup.
You've done all...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 12, 2014 at 1:41 am
You need to run that while the query mentioned earlier is running...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 12, 2014 at 1:38 am
It's not permissions (that would be an OS error 5)
From the error posted:
FileMgr::StartSecondaryDataFiles: Operating system error 2(The system cannot find the file specified.) occurred while creating or opening file 'D:\Program...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 12, 2014 at 1:37 am
Grant Fritchey (12/11/2014)
Also, when you're running queries against sys.dm_exec_requests you will see the resource that a given query is waiting on.
And sys.dm_os_waiting_tasks
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 11, 2014 at 7:05 am
Viewing 15 posts - 7,021 through 7,035 (of 49,552 total)