Questions tagged [sql-database]

Question about the Sitecore SQL databases - content, reporting, sessions, ...

Filter by
Sorted by
Tagged with
4
votes
1answer
669 views

Getting lots of System.ComponentModel.Win32Exception in the log

I'm getting lots and lots of System.ComponentModel.Win32Exception, Data.SqlClient.SqlException in my production CM sitecore log. Some times when use content editor or experience editor this error is ...
20
votes
2answers
6k views

How does the “Clean up databases” feature work?

In the Control Panel, there is a "Clean up databases" button. How does it work? What operations are carried out during a database cleanup?
2
votes
1answer
773 views

Direct SQL INSERT/UPDATE not showing on Web page

I'd use the API if having the choice, but right now I don't have the time for a learning curve, so I'm doing direct: UPDATE VersionedFields SET Value = 'Hypothesis Testing' WHERE Id = '...
7
votes
3answers
3k views

Sitecore Logging (Log4Net) Log to Database as Well as Text Files

Sitecore 7.5 The text file logging is working fine. But, I would like the logging to go to a SQL Server database so that I can search the data with T-SQL. How would I do that? I imagine it would be ...
12
votes
2answers
2k views

What is the purpose of the Analytics DB in Sitecore 8.x?

I'm migrating my Sitecore DBs from a local installation to Azure PaaS SQL instances using SSMS. I've successfully migrated Core, Master, Web and, with a small edit, Session. I'm having problems with ...
6
votes
2answers
930 views

What is Sitecore IDTable usage?

There is a table called IDTable that comes by default with Sitecore installations. What is the usage of this table ?
6
votes
1answer
890 views

Sitecore Azure SQL database maintenance

In this Sitecore on Azure Migration white paper http://www.slideshare.net/Jerrynott/azuremigrationwp004 It mentions on Page 17 It should be remembered that general database maintenance is still ...
1
vote
1answer
592 views

Database Query for Sitecore database final renderings fields

I want to query the Final renderings fields for an item in Sitecore directly against the database to check if they have ever had values. I have created the following query but want to be sure it's ...
9
votes
1answer
511 views

Server Role for SQL Server Account?

Connecting to SQL Server I currently have set the Server Role sysadmin on the account accessing SQL Server where I'm about to host Sitecore databases. My guess is that it's way to much privileges for ...
4
votes
3answers
2k views

Configuring private sessionState database raises runtime error:

I am trying to configure a mssql private sessionState database. I added the following to web.config's : <sessionState mode="Custom" customProvider="mssql" cookieless="false" timeout="20"> ...
14
votes
1answer
361 views

SQL wait times on EventQueue

Has anyone seen large wait times in SQL Server related to the Event Queue? Specifically, we are seeing ASYNC_NETWORK_IO being reported as a problem when accessing the Event Queue in SQL Server. We ...

1 2
3