Viewing 15 posts - 7,036 through 7,050 (of 49,552 total)
Depends how often you want to add space to your drives.
There's no need to have free space on the drive, as long as there's free space in the database 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 11, 2014 at 6:59 am
ALTER TRACE
And tell them to never use the Profiler GUI against a production server.
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 3:42 am
Too much of a hardware difference to say anything useful.
Execution plans of fast and slow?
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 3:40 am
TheBI (12/11/2014)
Too many deadlocks and timeouts?
???
and read commited snapshot is supposet to eliminate it
There's no isolation level that will eliminate timeouts. Timeouts are a result of queries running longer than...
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 2:17 am
Megha P (12/10/2014)
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 2:10 am
With read committed snapshot on, any request for read committed actually gets read committed snapshot. It's not a separate isolation level, it's read committed done with row versions.
Anything requesting serialisable...
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 2:07 am
Active-active never meant that both nodes were serving the same databases. That's never been how SQL clustering works. Active-active, before it went out of favour, used to mean two nodes...
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 10, 2014 at 2:20 pm
No, you're breaking it up wrong (because the indentation's been lost)
Resource 1:
pagelock fileid=1 pageid=539 dbid=5 objectname=databaseA_Live.dbo.TIMESHEET_HEADER id=lock30fdc4c00 mode=SIX associatedObjectId=72057602758672384
owner-list
owner id=process190617708 mode=SIX
waiter-list
waiter id=process4c87288 mode=S requestType=wait
Resource 2 (which is actually the exact...
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 10, 2014 at 2:17 pm
If the isolation level is enabled then you get the TempDB hit even if sessions are requesting other isolation levels. It's not necessarily going to be heavily used, depends on...
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 10, 2014 at 2:10 pm
OS error 5 is access denied.
If it's a share check the permissions on the share and the folder. Make sure that there isn't an existing file of the matching...
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 10, 2014 at 2:08 pm
This may be of use
https://www.simple-talk.com/sql/performance/sql-server-deadlocks-by-example/
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 10, 2014 at 9:07 am
Megha P (12/10/2014)
I found only CompileMemory Tag in Xml plan.Also don't found <MemoryFractions> tag.Is there anything that will be generated for memory grant in xml execution plan ?
Could be the...
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 10, 2014 at 6:54 am
Jason-299789 (12/10/2014)
GilaMonster (12/10/2014)
Probably the limit of the number of objects in a database. That's 2.3 billion, give or take.Memory is NOT the limit as temp tables are not memory-only.
Over and...
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 10, 2014 at 3:19 am
Not a perfmon counter. A property of the final operator in the query plan.
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 10, 2014 at 3:17 am
Assuming that the contents are already valid XML, then
ALTER TABLE <table name> ALTER COLUMN <column name> XML
should do it.
If the contents aren't valid XML, you'll have to fix...
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 10, 2014 at 2:45 am
Viewing 15 posts - 7,036 through 7,050 (of 49,552 total)